+ Reply to Thread
Results 1 to 2 of 2

Problem Date conversion

  1. 07-06-2011, 05:31 AM #1
    Ozdave
    Ozdave is offline
    Registered User
    Join Date
    12-16-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unhappy Problem Date conversion

    Hello please help if you can. I currently have an existing spreadsheet with a lot of data. the problem i have is one of the columns of data someone has put this date into the cell and i want to convert this but it does not do it in excel.
    here is the example data

    20000526
    year month day
    the closest thing is iso8601 without the seperators
    I would like it to be 26/05/2000 if possible

    I would like to convert this into a date I can use in other applications but I do not know how
    Could you please help?
    Reply With QuoteRegister To Reply
  2. 07-06-2011, 05:35 AM #2
    Domski
    Domski is offline
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    re: Problem Date conversion

    Select the values and then use Text to Columns and in step 3 choose the format as Date YMD.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1