Cell format changes

F

FP Novice

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

KARL DEWEY

You are asking an Excel question to an Access newsgroup, a relational database.
Your cell form is probably set to general and Excel is trying to help.
Change format to text.
 
F

FP Novice

Thanks Karl,
I noticed the posting to the wrong group just as you replied, sorry for the
mistake. No, the issue is that the cells are initially formatted as text,
after the replace tool is used the cells are formatted as date...which of
course is my problem.

Thanks again for the feedback, I have posted in the Excel forum...
 
Top