Enforcing a date format on a cell/column

P

ProdigalShawne

Hello,

I am working with a template that will also have protection on the worksheet.

One of the columns of the table will be a date column. I would like to
enforce the user to use the format mm/dd/yy. If they do not, I would like
the user to be notified that they are not using an accepted format and I
would like the template to not accept the data entered.

I have tried to set the format values to the date field and I have protected
the worksheet but I can still enter in the date any way I want. I am using
Validation on other columns, can I use it here as well and how would I do
that on a date format?

Any help would be much appreciated.

Thanks
 
K

Kevin B

Format the cells/column for dates and then clcik DATA on the menu and select
VALIDATION. Select DATE from the ALLOW combo box in the VALIDATION CRITERIA
panel of the SETTINGS tab in the dialog box. Set your to/from date range in
the start and end date fields and click OK.
 
Top