| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I change the default cell formatting to be text?
I would like Excell to treat all of the cells as text even if they contain
numbers, all the time. Is there some way to do this? I am interested in things like ($67,568) being changed to -$67,568 and things of this nature, I am using test to columns and it is always trying to change the format, so I would liek to be able to nit have to click through each column and change its format back to text. in reality my bigger probelm is I would like to create a document in which none of the content can be modified only the formatting. thanks Ian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| How to change default cell formats | Excel Discussion (Misc queries) | |||
Threaded Mode
