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.

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.

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
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528648

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

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528648