in reply to Changing time & date format
I believe that the date format is the number of days since 1st January 1900. Some versions of Excel (for Macs, for instance) may use days since the start of 1904, so you need to know the source of your text file.