Restricting user to enter the date in a particular format only !

S

sajjadhyder

Dear Members !

I need your help on the following case:

How can we restrict a user to enter the date in a particular format
only, and if any other format is tried for - the cell restricts the
user to do so. I would want to know how this is done without the use
of VBA.

Regards,
 
J

Jon Peltier

Couldn't you let the user enter the date in any format recognized by Excel,
then format the cell's appearance to show the date the way you want to read
it? If they can't get that right, make them enter year, month, and day in
separate cells and use =DATE(year, month, day) in the cell where the date is
displayed.

- Jon
 
Top