Sonia Bowditch
asked on
Excel 2007 Import from CSV into Excel Date Formatting Issue
When I import a file from CSV into Excel the dates imported change from UK formatting to a mixture of both US and UK. For example,
5/23/2013 11:27 9/22/2009
10 October 2013 04 June 2009 10 August 2008
9/22/2009 11:09 04 June 2009 10 August 2008
8/26/2011 8:35 9/22/2009
10 September 2008
07 April 2014 5/18/2011 3/16/2011
1/27/2012 14:38 5/20/2011 5/20/2011
Thanks.
Infosec36
5/23/2013 11:27 9/22/2009
10 October 2013 04 June 2009 10 August 2008
9/22/2009 11:09 04 June 2009 10 August 2008
8/26/2011 8:35 9/22/2009
10 September 2008
07 April 2014 5/18/2011 3/16/2011
1/27/2012 14:38 5/20/2011 5/20/2011
Thanks.
Infosec36
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I copy the data directly from the CSV file into the analysis spreadsheet instead of importing it via data import.
-Glenn