Thread: Entering dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tjtjjtjt
 
Posts: n/a
Default Entering dates

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.