Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Conversion
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Date conversion | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Disable automatic date conversion feature | Excel Worksheet Functions |