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

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


"SeeAll" wrote in message
...
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