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
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