Table of Contents

CalculateFormat Token

The %CalculateFormat%<formula>%<format>% token (v8+) returns the numeric result of performing a calculation. The formula is the same as for the Calculate token.

The <format> is either one of these specific localized formats:

or a format pattern according to Unicode Technical Standard #35.

Example patterns and results for the number 1234.567 in French locale are:

FormatAustralia France
#,##0.##
#,##0.###
###0.#####
###0.0000#
00000.0000
1,234.57
1,234.567
1234.567
1234.5670
01234.5670
1 234,57
1 234,567
1234,567
1234,5670
01234,5670

See Also

Tokens