Format Percentage Cells, Restrict Values >100.001
Posted on 2011-10-18
I have a percentage dilemma with Excel: I have ranges formatted as percentages and I'm tring to restrict the user from entering values greater than 100.001. Using Excel's Data Validation feature, the closest I can come to it and still force users to enter numbers and not text is:
Although this looks like it would work, it doesn't. Users can't enter text, but it still allows them to enter values greater than 100.001. I tried reversing the formula but that didn't work, and neither did using Whole Numbers Data Validation - that wouldn't let me enter squat on a cell formatted as a percentage no matter what the maximum number was.
Any help would be greatly appreciated!