The following table identifies the predefined numeric format names:
|
Format name |
Description |
|
General Number |
Display number as is, with no thousand separators. |
|
Currency |
Display number with thousand separator, if appropriate; display two digits to the right of the decimal separator. Note that output is based on system locale settings. |
|
Fixed |
Display at least one digit to the left and two digits to the right of the decimal separator. |
|
Standard |
Display number with thousands separator, at least one digit to the left and two digits to the right of the decimal separator. |
|
Percent |
Display number multiplied by 100 with a percent sign (%) appended to the right; always display two digits to the right of the decimal separator. |
|
Scientific |
Use standard scientific notation. |
|
Yes/No |
Display No if number is 0; otherwise, display Yes. |
|
True/False |
Display False if number is 0; otherwise, display True. |
|
On/Off |
Display Off if number is 0; otherwise, display On. |
Format Function, Format Function — Named Date/Time Formats.