how do I restrict cell input to dates only?
 

how do I restrict cell input to dates only? I want a message to be displayed
informing the user that only dates are allowed in the cell.

how do I restrict cell input to dates only?
 

Try data|validation.
On the settings tab, you can specify that the cell wants dates.

James E Slack wrote:

how do I restrict cell input to dates only? I want a message to be displayed
informing the user that only dates are allowed in the cell.

--

Dave Peterson

how do I restrict cell input to dates only?
 

Have a look at Data Validation
Under the "Allow" drop down choose date


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=492597