/
Number format

Number format

Owned by Support@Kenputer
Last updated: Mar 15, 2019

Please refer this link to detail formatting.

You can use the alias instead of format notation for a numeric result of a calculation.

AliasFormat
General Number#.#
Currency$ #,##0.00;[Red]$ -#,##0.00
Fixed0.00
Standard#,##0.00
Percent0.00%
Scientific0.00E+00
Yes/No"Yes";"Yes";"No"
True/False

"True";"True";"False"

On/Off'"On";"On";"Off"


Examples

FormatCalculate ResultDisplayed Value
#,###;[Red](#,###)]3254120032,541,200

-81000(81,000)
Percent0.1313.00%

Related content