Dates

Highlighted
New Contributor

I want to set up a date in excel so that the user only has to fill in the numbers. For example I want to have the format already set up and shown as __/__/____.  The user should only have to fill in the numbers while the cursor automatically advances.  Is there a way to accomplish this in excel?

2 Replies
Highlighted

That's not exactly what you'd like to have, as some approximation you may apply custom format to your cells like

##"/"##"/"####

and with it you may type dates with numpad only. 

 

Highlighted

This helped me very much.

Thank you, Sergei