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

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,

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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