format degrees, mg/l, parts per million

[Guest]

I would like to format cells in a similar maner that a date would be ( 6:30
PM ). But I want to use degrees in celcius ( litte circle and C ), parts per
million (ppm), and milligrams per litre ( mgl ).

Is there an option to do this in the custom menu perhaps. I can't seem to
find how.

Daryl C.

 

[Rob van Gelder]

From the Format menu | Cells | Custom
In the Type box:
0.00 °C

The degrees symbol can be entered by holding down ALT and typing 0176 on the
numeric keypad

 

[Jon Peltier]

In the same way, you can include any text in a numerical cell's
appearance. If the text contains a character which may confuse Excel's
formatting (like h,m,s or d,m,y) you should include the text in quotes:

0" ppm"
0.0" mg/l"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______