Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
any date entered before jan 1 1900 is being entered as text.. I understand
the dating system so this didn't surprise me.. any way around it? can I enter a date before Jan 1 1900 and have it stored as a date.. not text? this would go for jan 1, 1904 on a Mac as well.. thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
John Walkenbach's free Extended Date Functions addin handles dates from 400
through to 31-Dec-9999 http://j-walk.com/ss/excel/files/general.htm -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "barry" wrote in message ... any date entered before jan 1 1900 is being entered as text.. I understand the dating system so this didn't surprise me.. any way around it? can I enter a date before Jan 1 1900 and have it stored as a date.. not text? this would go for jan 1, 1904 on a Mac as well.. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel why does the date I enter automatically change by 1 day? | Excel Worksheet Functions | |||
I am entering date in Excel when I hit enter a formula appears? | New Users to Excel | |||
How do I format an Excel date earlier than 1900? | Excel Worksheet Functions | |||
Excel default date format | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) |