Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom formatting for text cells
Hi,
Not sure if this is possible but I have a column of text cells some starting witih SCF and the others without an SCF. I was hoping to get rid of the SCF on the cells that have them by using custom formatting. I do not want to create another column and use an if statment to get rid of the SCF because this will affect other things. Thanks, morgan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom formatting for text cells
Custom formatting only works with numbers and it can't change values.
If the only time SCF appears in any of the cells is at the beginning, then maybe an Edit|Replace would work for you. wrote: Hi, Not sure if this is possible but I have a column of text cells some starting witih SCF and the others without an SCF. I was hoping to get rid of the SCF on the cells that have them by using custom formatting. I do not want to create another column and use an if statment to get rid of the SCF because this will affect other things. Thanks, morgan -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom formatting for text cells
Alright thanks
Dave Peterson wrote: Custom formatting only works with numbers and it can't change values. If the only time SCF appears in any of the cells is at the beginning, then maybe an Edit|Replace would work for you. wrote: Hi, Not sure if this is possible but I have a column of text cells some starting witih SCF and the others without an SCF. I was hoping to get rid of the SCF on the cells that have them by using custom formatting. I do not want to create another column and use an if statment to get rid of the SCF because this will affect other things. Thanks, morgan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? | Excel Discussion (Misc queries) | |||
Formatting on unprotected cells | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |