View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rrupp rrupp is offline
external usenet poster
 
Posts: 22
Default How do I create a date format

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.