Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I disable automatic date formatting in excel?
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. |
#2
|
|||
|
|||
Import it as text
Regards, Peo Sjoblom "tcuneio" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
Date formatting in Excel | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |