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 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies