| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format changes
I have a large group of cells (48) whose format is text, with data that looks
like a date (1-9-01) but is not actually a date. When I use the replace function to change -9- to -10- it changes the format of the cells from text to date. How do I keep the replace function from overriding my chosen settings, without altering the way my data appears? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Threaded Mode
