Results 1 to 5 of 5

Problems recognizing dates from CSV import

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2013
    Posts
    3

    Problems recognizing dates from CSV import

    I need to import a lot of information from a large CSV file.

    Among others, it contains a timestamp that my Excel cannot recognize.
    It looks like this: 6/19/2017 10:27:30 AM

    (NB I'm using 24 and not 12 hours)

    I need the field to be recognized as a date and time, as I need to use it grouped in a Pivot table

    Can anybody help?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Not recognizing dates in column using Countifs
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2016, 02:51 PM
  2. Need to import table from website. Excel is not recognizing the table
    By elitelimfish in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 04:02 AM
  3. Excel not recognizing dates in correct order.
    By totlkaos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2012, 02:13 AM
  4. Not recognizing dates in drop down menu
    By SheilaV in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2010, 01:27 PM
  5. Recognizing European Dates as Dates in Excel 2007
    By sdekker22 in forum Excel General
    Replies: 1
    Last Post: 10-25-2009, 05:07 PM
  6. recognizing dates past End of Month
    By sk81222 in forum Excel General
    Replies: 6
    Last Post: 06-14-2006, 10:43 AM
  7. Excel not recognizing Dates properly.
    By Dan in forum Excel General
    Replies: 1
    Last Post: 03-23-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1