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 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. 

     

    • Denise555's avatar
      Denise555
      Copper Contributor

      This helped me very much.

      Thank you, Sergei 

Resources