How do I create a date format

[rrupp]

I have a user, in Excel 2003, that wants to type in just the numbers for a
date and have the / default in, like an input mask.
So, she'll type in 041708 for today (April 17th, 2008) but wants the / to
default in after the month, date. I have searched for input mask and I
thought I could create a custom, ##/##/## but not getting what I need. Any
thoughts?
I apologize if this is an easy one, I must be missing something.
Thanks for your time.

 

[Gary''s Student]

If the typed value is in A1, then in B1:

=DATE(2000+RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))

 

[Gord Dibben]

Excel has no function for creating date entry ",\masks"

You can use two cells as G'sS suggests or use event code from Chip Pearson to
enter 123456 in one cell and return 12:34:56 as valid time.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP