Chapter 24: Using Custom Number Formats
561
TABLE 24.5
Examples of Displaying Values in Thousands
Value Number Format Display
123456 #,###, 123(^1234565) #,###, 1,235
–323434 #,###, –323
123123.123 #,###, 123
499 #,###, (blank)
(^500) #,###, 1
123456 #,###.00, 123.46
(^1234565) #,###.00, 1,234.57
–323434 #,###.00, –323.43
123123.123 #,###.00, 123.12
499 #,###.00, .50
500 #,###.00, .50
Displaying values in hundreds
The following format string displays values in hundreds, with two decimal places. A value with this
number format appears as if it’s divided by 100 and rounded to two decimal places.
0”.”00
Table 24.6 shows examples of these number formats:
TABLE 24.6
Examples of Displaying Values in Hundreds
Value Number Format Display
546 0”.”00 5.46
100 0”.”00 1.00
9890 0”.”00 98.90
500 0”.”00 5.00
–500 0”.”00 –5.00
0 0”.”00 0.00