User Tools
token:CalculateFormat
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:
- Decimal
- Currency
- Percent
- Scientific
- Ordinal
- CurrencyISOCode
- CurrencyPlural
- CurrencyAccounting
or a format pattern according to Unicode Technical Standard #35.
Example patterns and results for the number 1234.567 in French locale are:
| Format | Australia | 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
- %Calculate% token
token/CalculateFormat.txt · Last modified: 2019/08/06 20:51 by peternlewis
