Cell format changes

  • Thread starter Thread starter FP Novice
  • Start date Start date
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?
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell format changes 3
Change text format to date format 2
Changing Data format 3
Excel conditional formatting with Weeknum 4
Date Formatting 1
Convert text to number or date 7
Comparison of columns using Conditional Formatting 3
Enter Date Format 9

Back
Top