XL's input parser doesn't pay attention to the format of the cell
(except if it's Text, in which case it doesn't parse the entry at all)).

Take a look he

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



In article <76cd7eb773151@uwe, "Launchnet" <u20911@uwe wrote:

Can someone tell me how to write a custom format code for Date Formatting.
I've seen this several years back and I don't remember the code which is
similar to mm/dd/yy and the / does not have to be entered each time on the
keyboard.

My daughter wants to enter 081507 and the cell formatting is to display
08/15/07

Thanks

Matt