Data Formatter

Enter formats without quote marks, with one exception: in chart settings, a format made only of zeros and a decimal point (such as 000.00, 00000 or .00) must be wrapped in single quotes, for example '000.00'. Without quotes it is ignored. Never put quotes around a format that starts with ( or +, or that contains {text}. Hover labels, axis labels, heatmaps, data grids and pivots will then drop the parentheses, plus sign or text.

Numbers

Number Format String
10000#,#.000010,000.0000
10000.23#,#10,000
10000.23+#,0+10,000
-10000#,#.0-10,000.0
10000.1234#.00010000.123
100.1234'00000'00100
1000.1234000000,0001,000
10'000.00'010.00
10000.12340[.]0000010000.12340
-10000(0,0.0000)(10,000.0000)
-0.23'.00'-.23
-0.23(.00)(.23)
0.23'0.00000'0.23000
0.230.[00000]0.23
12309740.0a1.2m
14600 a1 k
-1040000a-104k
10o1st
1000o100th

Currency

The currency symbol is always placed before the number. To show a symbol after the number, add it as text in curly brackets (see Text below).

Number Format String
1000.234$0,0.00$1,000.23
1000.20,0[.]00{ $}1,000.20 $
1001$ 0,0[.]00$ 1,001
-1000.234($0,0)$(1,000)
-1000.234$0.00-$1000.23
1230974$ 0.00 a$ 1.23 m

Bytes

Number Format String
1000b100B
10240b1KB
20480 ib2 KiB
30720.0 b3.1 KB
78844862130.00b7.88GB
34674796827870.000 ib3.154 TiB

Percentages

Number Format String
10%100%
0.9748782340.000%97.488%
-0.430 %-43 %
-0.43(0.000 %)(43.000) %

Text

Any text in curly brackets is shown exactly as typed, before or after the number. Use it for units, suffixes or symbols that would otherwise be read as format codes (such as $, %, a, b or o). In chart settings, don't put a comma followed by a space inside curly brackets, for example {, }. Chart settings are saved as one comma-and-space separated list.

Number Format String
1234.50,0{ users}1,235 users
12.50,0.0{ pts}12.5 pts
1500{~}0.0a~1.5k
1234560,0{%}123,456%