Date Conversion pre. 1900

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SeeAll - 29 Jun 2006 22:53 GMT

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

Reply to this Message

Peo Sjoblom - 29 Jun 2006 22:58 GMT

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

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

Signature

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

> Hi,
> Could someone help me with the following problem.
[quoted text clipped - 10 lines]
>
> SeeAll

Reply to this Message