Validating numeric input
The easiest way to do this is to use Excel's data validation feature.
This feature allows you to define the parameters of what can be entered in a cell.
Follow these steps: People can now enter only a numeric value within the range you specified. Since they are maintained internally, by Excel, as numbers, it is possible to enter a date, provided the date is parsed into a numeric value that is within the range you specify.
For instance, if you set up data validation to only allow values between 20,000 and 21,000, then someone could enter a date of 6/11/1956 because Excel parses the date to the whole number 20,617.
The best way to handle dates and times is to format the cell so that it uses a numeric format, which will stop Excel from displaying dates and times.
Excel Tips is your source for cost-effective Microsoft Excel training. where has i need to restrict the cell only for numeric entry it may be combination of any thing from 0 to 9 and the length of 6 only. I want to prevent the users to enter more than a specific value in a column.example if i set 100 is the highest value for that cell, users can only enter less than 100they enter more than that error msg should popup.
Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003.
If you are using a later version (Excel 2007 or later), this tip may not work for you.
For a version of this tip written specifically for later versions of Excel, click here: Limiting Entries to Numeric Values.
Gary has a worksheet that people in his office use for data entry.