Steve Swift
Board Regular
- Joined
- Jan 18, 2004
- Messages
- 187
Hi all,
This is driving me nuts can anyone help with this. I'm importing data from a txt file which is comma separated into excel 2007 using the wizard. I'm formatting all data as text during the import. The problem I'm having is that IF the data being imported COULD possibly be a date then excel insists it is and has the warning "Text Date with 2-digit year"
As a result these would have the error
11-06-41
30-11-75
and these would be fine because they could not possibly be a date.
40-47-79
08-92-86
30-94-04
I have spent hours searching for a solution. I have tried it on a variety of PC's with XP & Vista and Excel 2007 and all have the same problem. The closest I've come to a solution is it may be something to do with regional date settings but I have checked and these all use / as the separator and NOT the - I am trying to import as part of these numbers.
Any help or suggestions would be appreciated
I'm in the UK with UK regional settings.
Steve
This is driving me nuts can anyone help with this. I'm importing data from a txt file which is comma separated into excel 2007 using the wizard. I'm formatting all data as text during the import. The problem I'm having is that IF the data being imported COULD possibly be a date then excel insists it is and has the warning "Text Date with 2-digit year"
As a result these would have the error
11-06-41
30-11-75
and these would be fine because they could not possibly be a date.
40-47-79
08-92-86
30-94-04
I have spent hours searching for a solution. I have tried it on a variety of PC's with XP & Vista and Excel 2007 and all have the same problem. The closest I've come to a solution is it may be something to do with regional date settings but I have checked and these all use / as the separator and NOT the - I am trying to import as part of these numbers.
Any help or suggestions would be appreciated
I'm in the UK with UK regional settings.
Steve