See also
http://www.rondebruin.nl/qde.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Peo Sjoblom" wrote in message ...
Not possible without VBA (macro)
http://www.cpearson.com/excel/DateTimeEntry.htm
--
Regards,
Peo Sjoblom
"kwood525" wrote in message
...
I am trying to set up my date formatting so that I do not have to type in
the
forward slashes when I input the date. I would like to be able to just
type
in the date numbers: 083007
and have it automatically convert to: 08/30/07 when entered.
any tips?