How do I enter a date before 1900 in excel?

[woodrat]

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?)

 

[Norman Jones]

Hi Woodrat,

See John Walkenbach's Working With Pre-1900 Dates at:


http://www.j-walk.com/ss/excel/usertips/tip028.htm