View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Automatic Format Change: General to Date

Sounds like you are pasting in text that looks like dates. Pre-format as
text first.

Gustavo wrote:

Hello.

I apologize if duplicate, but tried looking for something similar in the
forum and didn't have luck.

Mi problem is that I have a file (new, not imported from a previous version)
that works fine until one point when all the numbers are changed in the
format from General to Date format. What can I do to prevent Excel of doing
this?

Thank you!