long dates before 1900
 

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

long dates before 1900
 

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

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

long dates before 1900
 

Hi,

have a look at this Addin

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


Mike

"Blackarrow143" wrote:

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

long dates before 1900
 

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

On Thu, 24 Apr 2008 05:03:01 -0700, Blackarrow143
wrote:

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