format degrees, mg/l, parts per million
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. |
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 -- Rob van Gelder - http://www.vangelder.co.nz/excel "dumbfounded" wrote in message ... 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. |
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/ _______ Rob van Gelder wrote: 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 |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com