Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enter a date before 1900 in excel?
In Excel I've formated a date column to be, say March 22 1956 after typing
3/22/1956. Is there any to get this to work so I could type in a date befor 1900 (by typing 11/2/1858 and get November 2 1858?) |
#2
|
|||
|
|||
Hi Woodrat,
See John Walkenbach's Working With Pre-1900 Dates at: http://www.j-walk.com/ss/excel/usertips/tip028.htm --- Regards, Norman "woodrat" wrote in message ... In Excel I've formated a date column to be, say March 22 1956 after typing 3/22/1956. Is there any to get this to work so I could type in a date befor 1900 (by typing 11/2/1858 and get November 2 1858?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Default date for date format | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) |