Current year in cell not 1900!!

[Tortus]

I've conditioned formated some cells so that someone can type a number in and a date will appear in the cell.

Problem is if someone types 20 in the cell.. excel reverts back to Jan-20-1900

How can I get the current month and year when a number is typed in the cell?

Did excel exsist in the 1900?

SOLVED
Solution - I used the if command in A2 like this

Please Login or Register  to view this content.

This was kind of a noob way of doing it but hey... I'm not real smart..

[shg]

Excel dates comprise a whole number and a decimal. The whole number is the days elapsed since 0 Jan 1900, and the decimal is the time. So 20 is 20 Jan 1900, which you could format in a variety of ways.

If you don't want it to look like a date, don't format it as a date.

[Tortus]

sigh... I wanted to be able to enter a number and get the date with the correct year.

How do you do the any command with IF? So I could spilt the date between 2 cells! Like

Please Login or Register  to view this content.

So what I am tring to do here is put this formula in A2 and if A1 has anything in it.. 2009 will show in A2. Not sure If I did the IF command right...??

[ikuogs]

Your formula looks alright. How do you condition format the cells? What do you want to see when somebody enter 1, 10, 100?

[Tortus]

Only conditional formating used is if the cell is blank I use no color. If the number in one cell is greater I change it to red and if it is less than the number I use green.

[shg]

This thread is marked solved. Did you do that, is it?

If not, please restate your question clearly.

[ikuogs]

Tortus typed SOLVED in the first message. I supposed it is solved by himself already.