No,I don't believe Excel won't do that. You can take a look at:
http://www.rondebruin.nl/qde.htm for a possible workaround.
--
tj
"instructorjml" wrote:
In Excel 2002, is there a built-in format that will automatically put slashes
into a date so that I only have to key the digits. For example, can I key
03122006 and see 03/12/2006 in the cell? I am sure it can be done in a custom
format, but I thought I may be missing a built-in function.
Thank you.