I have a table from an Access database that I am exporting into Excel to be
used in various spreadsheets. The Access table has numerous fields, but the
ones I will be using are account numbers, balances and dates for
transactions. The problem that I have is that the Access table is storing
the date as a number, specifically as a long integer. For example, December
31, 2003 is stored as 2453005. How can I convert this number into a date
once I get it into Excel? I tried just changing the date format from number
to date, but that gives me a date way off in the future, like ten years from
now.