Input mask for date

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Is there a way to make an input mask for a particular
column so theat the only entry will be a date, mm/dd/yy?
I've gone to format, cells, number, date and picked a
particular format but this still allows other information
to be entered in the column.

Thanks.
 
Peter

use Data | Validation... | Allow date

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top