0

If the character in the position of the 0 is a number, the number is used. If not, a zero is used.

0#### →
01350

#

If the character in the position of the # is a number, the number is used. If not, no value is placed in this position.

If the number of # and 0 that is placed before the decimal point is lower than the value to be shown, the complete value is shown.

##### →
1350

## →
1350

.

A decimal point. This is used to indicate that you want to include numbers after the decimal point in the report. The decimal point is used depending on the locale of the Planon ProCenter language used by the logged in user.

If the number of # or 0 placed after the decimal point is less than the number of decimal places to be shown, the value is rounded up or down. This also applies if no numbers are used after the decimal point.

####.#00 →
1350.45

#.## →
0.26

0.26 →rounded up to 0.3

,

For numbers over 999 a separation mark is used. The grouping symbol is determined by the locale of the Planon ProCenter language used by the logged in user.

#,### →
1,350

‘ ’

Text placed between single quotation marks is included in a report.

‘The United Kingdom has’ #.### ‘points.’ →
The United Kingdom has 1.350 points.

;

A mask contains a positive and negative subpattern, for example, "#,##0.00;(#,##0.00)".

Each subpattern in the mask has a prefix, numeric part, and suffix.

The negative subpattern is optional; if absent, then the positive subpattern prefixed with the localized minus sign ('-' in most locales) is used as the negative subpattern.

That is, "0.00" alone is equivalent to "0.00;-0.00".

If there is an explicit negative subpattern, it serves only to specify the negative prefix and suffix; the number of digits, minimal digits, and other characteristics are all the same as the positive pattern. That means that "#,##0.0#;(#)" produces precisely the same behavior as "#,##0.0#;(#,##0.0#)".

####;
-0####

1350
→1350

-01350
0 → -1350

#,##0.00;(#,##0.00) 123456.78 → 123,456.78

#,##0.00;(#,##0) -123456.78 → (123,456.78)