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

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. 



This helped me very much.

Thank you, Sergei