Dates

Denise555
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