Numeric Format Codes
Code Description Example
9 Numeric digits with leading space if positive and leading minus if negative. 9999.9 -> 1234.5
0 Leading and/or trailing zeros. 0009.90 -> 0003.40
, Comma, for use as a group separator. It cannot appear after a period or decimal code. 9,999.00 -> 1,234.20
G Local group separator, could be comma or period. 9G999D9 -> 1,234.5
9G999D9 -> 1.234,5
. Period, for use as teh decimal character. It cannot appear more than once or to the left of a group separator. 9,999.00 -> 1,234.20
D Local decimal character, could be comma or period. 9G999D9 -> 1,234.5
9G999D9 -> 1.234,5
$ Dollar sign currency symbol. $999 -> $123
L Local currency symbol. L999 -> £123
RN Uppercase Roman numerals. RN -> XXIV
rn Lowercase Roman numerals. rn -> xxiv
X Hexadecimal XX -> F9