Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting issue
I have a colume within which is entered chemical concentrations in either :
Molarity - thus 1.6M Concentration - thus 50% The column is formatted as a % so that the concentartion number come out correct, however i find that the molarity data is formatted as 1.6M% ??? I dont want the % at the end of the molarity. Can anyone help? Thanks, Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting issue
A cell can only have one format. You can set it to no format, then as you
enter a number requiring a percent, you can press the % icon. "Roger on Excel" wrote: I have a colume within which is entered chemical concentrations in either : Molarity - thus 1.6M Concentration - thus 50% The column is formatted as a % so that the concentartion number come out correct, however i find that the molarity data is formatted as 1.6M% ??? I dont want the % at the end of the molarity. Can anyone help? Thanks, Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting issue | Excel Worksheet Functions | |||
CSV formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue ??? | Excel Discussion (Misc queries) | |||
formatting issue? | Excel Discussion (Misc queries) | |||
formatting issue | Excel Programming |