Dates in cell - HELP!!!

Sondra · Nov 18, 2003

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 · Nov 18, 2003

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
[email protected]

Jordon · Nov 18, 2003

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