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

On Mon, 26 Sep 2005 05:00:47 -0500, ashvik
wrote:


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


Use Data Validation and on the 'Settings Tab' pick the 'Whole number'
option and set it to be between 1-100.

In addition and optionally, you can use the 'Input Message' or Error
Alert' tabs to let the user know what values you expect.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________