Entering dates

[Guest]

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.

 

[Guest]

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.

 

[gjcase]

You could format the entry cells as text and use a column next to them
to display a date by parsing the text. If the text were in M2, N2
would contain (=LEFT(M2,2)&"/"&MID(M2,3,2)&"/"&RIGHT(M2,2)

---GJC

 

[gjcase]

Sorry, please ignore the leading ( in the previous post. Happy
fingers...

---GJC