Custom number formats (Excel 2000)

[ChrisGreaves]

I had occasion to delve into this and thought to share what I learned.
A worksheet has results in Kilowatt-Hours and in Horsepower.
I created two styles:

Code: Select all

KWhr2
#,##0.00 "KWhr"

and

Code: Select all

HP2
#,##0.00 "HP"

Both styles display two decimal digits (hence the suffix in their names).
It took me a minute or two to figure out that the strings had to be enclosed in double-quotes.

[HansV]

You can also prefix a character with a backslash to tell Excel to take it literally instead of as a formatting code. This is especially useful if you want to add just a single character:

Metres

#,##0.00 \m

is equivalent to

#,##0.00 "m"