Dates in cell - HELP!!!

[Sondra]

I want to be able to add a date to cells without having to
use the /; however when I enter the date as 111803 the
results of the cell is 2/7/2206. What am I not doing???

Thanks in advance

 

[Nick Hodge]

Sondra

Your not entering the / as you already know. Excel will not recognise it a
s a date without the /
For possible solutions and a better understanding try


http://www.cpearson.com/excel/datetime.htm
http://www.cpearson.com/excel/DateTimeEntry.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Jordon]

You can enter dates without the /.

If the cell is formatted as a date and you enter what
the OP entered (111803) you will indeed get February
7th 2206. That day is the 111803rd day since the beginning
of Excels date system.

Jordon