Forum Discussion

Denise555's avatar
Denise555
Copper Contributor
Nov 30, 2018

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 ...
developer
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 30, 2018

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. 

 

  • Denise555's avatar
    Denise555
    Copper Contributor
    Nov 30, 2018

    This helped me very much.

    Thank you, Sergei