| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing .txt data into Excel
I am trying to import a .txt file with a 6 digit date into Excel. The date
is formatted as a mmddyy and when changing this field to a date excel seems to translate any yy = 30 as 1930 instead of 2030? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing data into Excel | Excel Discussion (Misc queries) | |||
| Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
| Importing data into Excel | Excel Discussion (Misc queries) | |||
| Importing data into excel | Excel Worksheet Functions | |||
| Importing data into Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
