Excel converts .csv imported date field into mm/dd/yyyy format

[r_kaw]

I'm importing data from a comma separated text file into excel.
The date in the original text file is presented as 2010-02-02, however when it gets imported into excel as a csv file, the date's formatting changes automatically to 02/02/2010, which I think is clever and cool.

However, when I load the .csv file into another application ( A data modelling application written in C++ years ago whose source code is lost), it is able to see the data of the date field as it was in the text file and stops loading the data.

Somehow it is able to see through the cleverness of Excel and see the date data for what it was. i.e. 2010-02-02 and not 02/02/2010

If I manually overwrite that data in the date field to 02/02/2010, the application has no problem in using the data field.

So I need to have the date in the csv file to be written as 02/02/2010 overwriting the original data 2010-02-02 with 02/02/2010.

I'd manually change the date data, except I'd have close to 80 files each week to modify then.

Grateful for any ideas.....
Thanks in advance

Using Excel ver. 2003 on Windows XP.

R Kaw

 

[Joe4]

Welcome to the Board!

Since you know that Excel is converting it the way you want it, try importing it into Excel, and then re-saving the CSV file from Excel, which should convert it for you.

 

[r_kaw]

That idea worked !! Thanks for the suggestion.

I appreciate it.

RK