Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006

    Unanswered: Text number to Date Format?

    My IT Manager has a spreadsheet that he imported some 40,000 dates into.
    They are all formatted as text though, so we cannot simply change the cell format to receive the correct date. It takes the number, gives it a date format, but completely alters the date to something foreign. Can someone please show me how to convert this data via VB or some other way (leaving it in Excel) to reflect the right date. See attachment for what we are trying to accomplish on a larger scale. TIA.
    Attached Thumbnails Attached Thumbnails Screen Print.jpg  

  2. #2
    Join Date
    Oct 2003
    Howdy and welcome to the board.

    If you want to use another column to make it look like date, then use this formula for C1


    If you need it eventually in true date, then copy/paste special values.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2006

    Thank you!

    Rich ~

    Thanks for the info - it works perfect!
    You da man!

  4. #4
    Join Date
    Mar 2006
    Why not just use Data>Text to columns... and select MDY on the 3rd step?

Posting Permissions

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