View Single Post
 
Old 09-17-2013, 04:48 AM
sjp1966 sjp1966 is offline Windows XP Office 2007
Novice
 
Join Date: Mar 2012
Posts: 21
sjp1966 is on a distinguished road
Default

Hi Bob

Sorry. This is when we view the CSV in Excel. I am actually thinking that this maybe an issue with excel.

I am being given a CSV file.
I open it in excel and the dates are dd/mm/yyyy
I reformat dates to yyyy-mm-dd
when I save I get the contains formatting error that happens on every csv in the world I think.
When I relook in excel the date revert to dd/mm/yyyy
however if I look at the CSV in notepad they are the yyyy-mm-dd format
so I am wondering if excel is changing this information.
Reply With Quote