How do I disable automatic date formatting in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing data into Excel which contains codes. Some of the codes are
similar to dates (ex. 4feb1) and they are automatically converted. I need
the codes to remain as is.
 
I will see if I can control this. I'm importing data directly from AutoCAD
and am not sure that I can control this. If I can't, is there no other way
to disable the automatic formatting by Excel?
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
Data being corrupted by excels automatic date recognition re-forma 6
automatic date formatting 1
text string: "91E10" in csv file auto converts to: "9.10E+11" 2
How to disable General formatting when opening CSV 1
Calculate number of rows and apply formula 4
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excel Import External Data by Date Automatically 0

Back
Top