Excel 2007 Import from CSV into Excel Date Formatting Issue

Posted on 2014-08-13
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

Question by:infosec36
    LVL 27

    Expert Comment

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


    Accepted Solution

    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.


    Author Closing Comment

    I copy the data directly from the CSV file into the analysis spreadsheet instead of importing it via data import.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
    To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
    The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now