+ Reply to Thread
Results 1 to 2 of 2

Date format conversion issue

  1. 06-13-2014, 06:29 AM #1
    kesavanprabhu
    kesavanprabhu is offline
    Registered User
    Join Date
    05-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    41

    Date format conversion issue

    Hello,

    I am downloading a report from an ERP the date column in the report will be as shown below in the example now i could not sort this in excel and moreover i need to change this to ddmmyy.

    Please help in resolving this.

    Example
    Delivery Order (YYMMDD)
    14-06-06
    14-06-06
    14-06-06
    14-05-22
    14-05-22
    14-05-22
    14-05-22
    14-05-23
    14-05-23
    14-05-23
    14-05-23
    14-06-02
    14-06-06
    14-06-06
    14-06-06

    Thanks in advance...
    Reply With QuoteRegister To Reply
  2. 06-13-2014, 07:05 AM #2
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Date format conversion issue

    Hi,

    You can use Text0-To-Columns to quickly sort this conversion issue out.
    See this image: 1.jpg

    1. Select the text dates
    2. Access Data ribbon
    3. Text-To-Columns
    4. Click NEXT twice to get to step 3 and change the option button to date (and select the correct format YMD)
    5. Click Finish

    The dates will automatically convert to a valid date format.
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conversion de date d'un format personnalisé à un format de date standard
    By vince555 in forum Excel General
    Replies: 1
    Last Post: 06-15-2012, 02:03 PM
  2. Date conversion issue with year
    By maacmaac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2009, 05:38 PM
  3. Conversion of date into different format
    By Fam via OfficeKB.com in forum Excel General
    Replies: 8
    Last Post: 07-31-2006, 04:18 PM
  4. Format:Date conversion
    By Kristiaaan in forum Excel General
    Replies: 5
    Last Post: 07-30-2005, 01:05 AM
  5. Date conversion issue... again
    By Dimmer in forum Excel General
    Replies: 6
    Last Post: 07-11-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1