Date Conversion pre. 1900

SeeAll · Jun 29, 2006

Hi,
Could someone help me with the following problem.

I need to convert dates from:

01/02/1800 to 1 Feb 1800

I know excel's default year is 1900.

Any help would be appreciated.

Regards

SeeAll

Peo Sjoblom · Jun 29, 2006

John Walkenbach has an add-in where you can use pre 1900 dates

http://j-walk.com/ss/excel/files/xdate.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey