+ Reply to Thread
Results 1 to 2 of 2

Converting dates from Excel 07 to 03

  1. #1
    Registered User
    Join Date
    05-21-2010
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    1

    Converting dates from Excel 07 to 03

    I have been given an excel 2007 file. I only have office 2003 so opened it using the Microsoft Open XML Converter.
    When opened, the dates are showing as long numbers e.g 83396 and 83403. I've tried changing the formating (format - cells - number - and choosing a date format dd/mm/yy) but the dates convert to 29/04/28 and 06/05/28 respectively. I know the dates are all from January 2010 but can't work out how to convert them. I have tried clearing all the formatting but am getting nowhere! help!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Converting dates from Excel 07 to 03

    Those integers relate to the year 2128 on a 1900 date system (21-May-2010 being 40319). Ask whomever gave you the 2007 file to save it as an .xls file and review the values within.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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