How to set a column to accept only a specified number of digits

A

ashvik

Hi,

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

Thank
 
R

Richard Buttrey

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
Click to expand...


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
__________________________
 
Top