Hi
you can't enter date values this way. You need VBA for this. See:
http://www.xldynamic.com/source/xld.QDEDownload.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Del" schrieb im Newsbeitrag
...
Hello,
I am having a weird problem trying to format a cell to the date
format
mm/dd/yy.

When I enter a date of 111904 it returns a formatted date of:
05/19/06

Can anyone help?

Thanks in advance!!!!

Del