Microsoft Office Tutorials and References
In Depth Information
Using Custom Number Formats to Scale Values
Table 50-2 shows examples of number formats that scale values in thousands.
Table 50-2: Examples of Displaying Values in Thousands
Value
Number Format
Display
123456
#,###,
123
1234565
#,###,
1,235
–323434
#,###,
–323
123123.123
#,###,
123
499
#,###,
(blank)
500
#,###,
1
500
#,###.00,
.50
Table 50-3 shows examples of number formats that display values in hundreds.
Table 50-3: 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
 
Search JabSto ::




Custom Search