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 