Re: $$Excel-Macros$$ Excel misinterprets dates in CSV files

2013-11-25 Thread ashish koul
try to change the current location to Canada as well and also please check the date in additional settings as well in Region and Language On Tue, Nov 26, 2013 at 12:26 AM, Trevor Barrie wrote: > Hi all, > > I'm having a problem with importing CSV files into Excel. My CSVs contain > dates forma

$$Excel-Macros$$ Excel misinterprets dates in CSV files

2013-11-25 Thread Trevor Barrie
Hi all, I'm having a problem with importing CSV files into Excel. My CSVs contain dates formatted Canadian style, dd/mm/. However, when some users open these files, Excel interprets the date as mm/dd/. (So the text string "01/09/2013", which should mean Sep 1 2013, becomes Jan 9 2013. T