The syntax for numeric values is given below.
| Code | Description |
|---|---|
|
. |
Decimal point |
|
, |
Separator (for instance to separate 1000s) |
|
‘ |
Insert a single quote at start and end of any string to indicate plain text |
|
% |
Multiplies the value by 100 and displays it as a percentage |
|
E |
Use in scientific notation to separate the mantissa and the exponent (for example, #E+00) |
|
# |
A digit (omitted if zero) |
|
0 |
A digit (still displayed, even if the value is zero) |
Example:
Using the syntax #,### results in the value 1000000 being displayed as 1,000,000 (the separator automatically repeats for each occurrence of three digits—there is no need to include a further separator)
Using the Custom syntax 0E0 results in the value 900 being displayed as 9E2
A value formatted using a Number category format with two digits after the decimal place appears as .75
To display a leading zero before the decimal point, use the custom syntax 0.## (or 0.00 to always display two digits after the decimal place)
The value then appears as 0.75
Using the Custom syntax #% results in the value 0.75 being displayed as 75%
The Custom syntax ‘Weight: ‘ 0.## results in the value 0.75 being displayed as
Weight: 0.75.