CSV Date Formats

[sjp1966]

Hi

I wonder if someone could help with a date format issue in csvs, I have done a google search and I just dont understand some of the answers that Ive found

Product: Excel 2010
O/S: Windows 7 64bit

I have a guy at work that has exported a csv file, in it are dates, they need to export this file into another application and the date need to have the format as yyyy-mm-dd, we are seeing them as dd/mm/yyyy.



Ive tried chnaging input language, ive tried doin the import as data > comma delimited then changing the column heading to YMD, but to no avail. Is there an easy way to change the date format of CSV document?

thanks

Steve