| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter a date before jan 1, 1900 into excel?
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
|
|||
|
|||
|
how do i enter a date before jan 1, 1900 into excel?
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
