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