Pete

Download John Walkenbach's Extended Dates add-in.

You can work with dates prior to 1900.

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


Gord Dibben Excel MVP

On Wed, 30 Mar 2005 11:49:05 -0800, Pete the Mag
wrote:

I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834.
Can this be done?

Thanks