Forum Discussion
Denise555
Nov 30, 2018Copper Contributor
Dates
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?
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.
- Denise555Copper Contributor
This helped me very much.
Thank you, Sergei