Date Formatted Cells

[Mike]

I would like to know how to format cells so when I enter "090404", 9/04/04 is
displayed in the cell. 09/04/04 would work as well. I only want to have to
type six numbers for the date, and for Excel to recognize and interpret the
date and print it in the above format. Is there a way to do this?

When I try to do this, I go to Format and then to Date and select the format
I want, however, Excel does not recognize "090404" as a date, it accepts it
as some date serial number or something and gives me the wrong date.

Please help.

Mike

 

[Peo Sjoblom]

Only by using macro

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

Regards,

Peo Sjoblom

 

[JE McGimpsey]

The format of the cell doesn't affect how the parser interprets your
entry (except if format is set to Text). You'll need to use an event
macro.

See

http://cpearson.com/excel/datetimeentry.htm

 

[Frank Kabel]

Hi
use the following addin:
http://www.xldynamic.com/source/xld.QDEDownload.html