I format for date but it is calculating

[Guest]

I formatted column for date, ie mm/dd/yy

However, when I enter in 060806 I get 03/19/69

I want to see 06/08/06. What is wrong?

I think it is making some sort of calculation.

 

[Guest]

Okay, I understand that Excel is thinking the number I am putting in (060806)
is a serial number for the date of 03/19/69. Is there a way to make it do
what I want. i didn't see it on www.cpearson.com/excel/datetime.htm

 

[Guest]

As far as I am aware, dates must entered as mm/dd/yy(yy) or mm-dd-yy(yy) i.e.
you need the delimeters.

Using VBA, it would be possible to allow entry as you tried and convert to a
date.

HtH

 

[Dave Peterson]

Chip's site:
http://www.cpearson.com/excel/DateTimeEntry.htm