Validating numeric input

Posted by / 21-Jan-2016 03:08

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.

validating numeric input-11validating numeric input-12validating numeric input-83

Gary has a worksheet that people in his office use for data entry.

One thought on “validating numeric input”

  1. I’ve brought my children to shul over the years much as possible, and tried my best to foster in them the desire to embrace and continue their involvement in the Jewish faith, but has it all been for naught?