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?
|