Numbers may be formatted in a locale-sensitive manner.
You can choose one of several predefined formats, or type in a custom format string:
Value |
Format Pattern |
Formatted Number |
123456.78 |
Standard |
123,456.78 |
0.12 |
Percentage (###.00%) |
12% |
0.12 |
Scientific |
1.20E -1 |
1234.78 |
Scientific |
1.23478E+3 |
Symbol |
Description |
% |
Percentage. The value is multiplied by 100 and a percent sign is appended. |
E- or e |
Scientific notation with a minus sign (-) next to negative exponents and nothing next to positive exponents. This symbol must be used with other symbols, as in 0.00E –00 or 0.00E00. |
E+ or e+ |
Scientific notation with a minus sign (-) next to negative exponents and a plus sign (+) to positive exponents. This symbol must be used with other symbols, as in 0.00E+00. |
0 |
Digit placeholder, display a digit or 0 |
# |
Digit placeholder, display a digit or nothing |