Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates prior to 1900 are text
Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
are not formatted as dates, but seem to become text. I can't do calculations between such dates...what gives? Anyone know how to over come this horrible limitation? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates prior to 1900 in Excel | Excel Discussion (Misc queries) | |||
Excel dates prior to 01/01/1900 | Excel Discussion (Misc queries) | |||
How do I get Excel to recognise dates prior to 1/1/1900 ? | Excel Discussion (Misc queries) | |||
Formatting dates prior to 1900 | Excel Discussion (Misc queries) | |||
Dates prior to 1900 | Excel Worksheet Functions |