Data Formatter

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.1234'000000,0'001,000
10'000.00'010.00
10000.1234'0[.]00000'10000.12340
-10000'(0,0.0000)'(10,000.0000)
-0.23'.00'-.23
-0.23'(.00)'(.23)
0.23'0.00000'0.23000
0.23'0.0[0000]'0.23
1230974'0.0a'1.2m
1460'0 a'1 k
-104000'0a'-104k
1'0o'1st
100'0o'100th

Currency

Number Format String
1000.234$0,0.00$1,000.23
1000.2'0,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
100'0b'100B
1024'0b'1KB
2048'0 ib'2 KiB
3072'0.0 b'3.1 KB
7884486213'0.00b'7.88GB
3467479682787'0.000 ib'3.154 TiB

Percentages

Number Format String
1'0%'100%
0.974878234'0.000%'97.488%
-0.43'0 %'-43 %
0.43'(0.000 %)'43.000 %