Input Cells

F

Frick

Is there a way to restrict input cells to only allow for input based on the
format of the cell?

For example suppose A1 is formatted for a date. Can the cell be restricted
to prevent someone from entering text or a number.

Thank you for any help provided.

Frick
 
P

Peo Sjoblom

It's not a 100% way but under data>validation you can specify dates and lots
of conditions like between 2 dates, greater than a date and so on It will
certainly keep out typed text

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Top