View Single Post
  #1   Report Post  
ashvik
 
Posts: n/a
Default How to set a column to accept only a specified number of digits


Hi,

Can u tell me how to set a column in excel to accept only a specify
number of digits? for example ... i want column A to accept only
numbers in the range 1-100. If 101 is type an error must be displayed

Thanks


--
ashvik
------------------------------------------------------------------------
ashvik's Profile: http://www.excelforum.com/member.php...o&userid=27543
View this thread: http://www.excelforum.com/showthread...hreadid=470697