Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel 2007 Import from CSV into Excel Date Formatting Issue

Posted on 2014-08-13
3
Medium Priority
?
195 Views
Last Modified: 2014-08-19
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
0
Comment
Question by:Sonia Bowditch
  • 2
3 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40259740
Can you attached a sample of the actual CSV file?  The above text doesn't provide a good indicator of the source data.

-Glenn
0
 

Accepted Solution

by:
Sonia Bowditch earned 0 total points
ID: 40260003
Hello Glenn,
I have found a work around for the problem I was experiencing.  The underlying CSV file date format was correct but when importing it into a spreadsheet via data import it lost its formatting.    I now copy the data directly from the CSV file into the analysis spreadsheet and it keeps the formatting.

Thanks
Infosec36
0
 

Author Closing Comment

by:Sonia Bowditch
ID: 40269789
I copy the data directly from the CSV file into the analysis spreadsheet instead of importing it via data import.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Gain an elementary understanding of Blockchain technology.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question