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!
Bookmarks