long dates before 1900

[Blackarrow143]

I am entering dates from the 1800's and 1900's. I want to produce dates as '
1 Mar 1845'. How can I do this?

Thanks in advance

Blackarrow143

 

[Alan]

Have a look here,
http://www.j-walk.com/ss/excel/files/xdate.htm

 

[Mike H]

Hi,

have a look at this Addin

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


Mike

 

[Gord Dibben]

Excel does not recognize dates before 1900 as valid dates and will treat them as
text.

To work around this see John Walkenbach's site.

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


Gord Dibben MS Excel MVP