Display Format is a cell option available to a number cell type only. Designer can set up a display format for the numbers.
Display format is used in KPI values as well.
Format patterns with examples:
Numbers
|
Number |
Format |
Result |
|
10000 |
0,0.0000 |
10,000.0000 |
|
10000.23 |
0,0 |
10 |
|
10000.23 |
+0,0 |
10 |
|
-10000 |
0,0.0 |
-10,000.0 |
|
10000.1234 |
0.000 |
10000.123 |
|
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 |
|
52 |
0o |
52nd |
|
23 |
0o |
23rd |
|
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 |
|
2048 |
0 b |
2 KB |
|
7884486213 |
0.0b |
7.3GB |
|
3,46748E+12 |
0.000 b |
3.154 TB |
Percentage
|
Number |
Format |
String |
|
1 |
0% |
100% |
|
0.974878234 |
0.000% |
97.488% |
|
-0.43 |
0 % |
-43% |
|
0.43 |
(0.000 %) |
43.000 % |
0 Comments