How do I enter a date before 1900 in excel?
 

In Excel I've formated a date column to be, say March 22 1956 after typing
3/22/1956. Is there any to get this to work so I could type in a date befor
1900 (by typing 11/2/1858 and get November 2 1858?)

You may want to check this out:
http://www.j-walk.com/ss/excel/usertips/tip028.htm

tj

"woodrat" wrote:

In Excel I've formated a date column to be, say March 22 1956 after typing
3/22/1956. Is there any to get this to work so I could type in a date befor
1900 (by typing 11/2/1858 and get November 2 1858?)

Hi tjtjjtjt,

My apologies, when responding to OP I did not see your response in the
thread and so, duplicated your link at a distance of several hours!

---
Regards,
Norman



"tjtjjtjt" wrote in message
...
You may want to check this out:
http://www.j-walk.com/ss/excel/usertips/tip028.htm

Oops, I've should've put a 'see your other post' messge up for the OP. Sorry
about that.

tj

"Norman Jones" wrote:

Hi tjtjjtjt,

My apologies, when responding to OP I did not see your response in the
thread and so, duplicated your link at a distance of several hours!

---
Regards,
Norman



"tjtjjtjt" wrote in message
...
You may want to check this out:
http://www.j-walk.com/ss/excel/usertips/tip028.htm