Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a formatting problem
I have cells with a general format so when i type something it comes out as typed. However... If I type a % number in for example 50%. If I retype text into the same cell afterwards it come out as text%, retaining the percentage format. Even when I reapply the general format from the format cells dialog, or use the format painter, the % doesnt go away. I have to manually select the text and delete the % sign. Can anyone offer help on how to revert the cells back to general format to stop the percentage format dominating when it is used? Thanks, Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing number format | Excel Worksheet Functions | |||
How to remove Hyperlink without changing cell format? | Excel Worksheet Functions | |||
Changing Number Format | Excel Programming | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Changing a cell's number format | Excel Programming |