Date Conversion pre. 1900

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>