Input mask for date
 

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.

Input mask for date
 

Peter

use Data | Validation... | Allow date

Regards

Trevor


"Peter" wrote in message
...
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.