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