| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dates prior to 1900 are text
John Walkenbach has an addin that may help you:
http://j-walk.com/ss/excel/files/xdate.htm xp wrote: 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? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dates prior to 1900 are text
see:
http://j-walk.com/ss/excel/files/xdate.htm -- Gary''s Student - gsnu201001 "xp" wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dates prior to 1900 are text
You need to treat that dates as numbers and at the end present the result as
a text that looks like a date. "xp" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
