How do I enter a date before 1900 in excel?

G

Guest

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?)
 
N

Norman Jones

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!
 
G

Guest

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

tj
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Function Help 4
Date returns always returns: 00 January 1900 2
How do I Modify Julian calendar restriction of 1900 2
Please help! date showing as 1900/01/00 2
Returning a YES or NO if there is a value on a range of cells 0
Dates before 1900 2
Dates Before 1900 1
Dates before 1900 and Year function 1

Top