The pattern must contain at least one digit symbol [#], [,] must be used as the grouping separator and [.] must be used as the decimal separator. The positive pattern is given first, followed by a separator symbol [;], the an optional negative pattern. If the negative pattern is not given, [-] will be used as a prefix for negative numbers.
All characters are translated literally, except for the following symbols:
|0 ||Digit |
|# ||Digit, zero shows as absent |
|. ||Decimal separator or monetary decimal separator |
|- ||Minus sign |
|, ||Grouping separator |
|;||Separates positive and negative subpatterns |
|' ||Used to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row: "# o''clock". |
Any character which is not a symbol can be defined as the "Number grouping separator" or "Number decimal separator"