Character

Location

Localization Status

Use

0

Number

Yes

Digit

#

Number

Yes

Digit Zero shows as absent.

.

Number

Yes

Decimal or monetary separator

-

Number

Yes

Minus sign

,

Number

Yes

Grouping separator

E

Number

Yes

Separates mantissa and exponent in scientific notation. You do not need to quote in prefix or suffix.

;

Subpattern boundary

Yes

Separates positive and negative subpatterns

%

Prefix or suffix

Yes

Multiplies by 100 and shows as a percentage

\u2030

Prefix or suffix

Yes

Multiplies by 100 and shows as per mill

(\u00A4)

Prefix or suffix

No

Currency sign, replaced by currency symbol. If doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator.

'

Prefix or suffix

No

Quotes special characters in a prefix or suffix. For example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row, such as in "# o''clock".