EXCEL
Custom Formats for Numbers
|
Format for positive
numbers |
Format for zeros |
|
#,###.00_); |
[Red]
(#,###.00); |
0.00; |
~sales~@ |
|
Format for negative numbers |
Format for text |
|
To display |
Use this code |
| 1234.59 as 1234.6 |
#.# |
| 8.9 as 8.900 |
#.000 |
| .631 as 0.6 |
0.# |
| 12 as 00012 and 123 as 00123 |
00000 |
| 12 as 00012 and 123 as 000123 |
"000"# |
| 12 as 12.0 and 1234.568 as 1234.57 |
#.0# |
| 44.398, 102.65 and 2.8 with
aligned decimals |
???.??? |
| 5.25 as 5 1/4 as 5.3 as 5 3/10
with aligned division symbols |
# ???/??? |
Thousands
separator
To
display a comma as a thousands separator or to scale a number by a multiple of
one thousand, include a comma in the number format.
| To display |
Use this code |
| 12000 as 12,000 |
#,### |
| 12000 as 12 |
#, |
| 12200000 as 12.2 |
0.0,, |
You may also want to add currency symbols, percentages,
scientific notation, characters,
colour or padding spaces
to your custom number format. Click the links to see how to do this.
If you want to display a blank instead of a zero when the value of a cell is 0,
see the page on adding a text section.
Click here to
return to the Excel index.
webmaster@allaboutoffice.co.uk |
