I have a cell that has a format of Percentage with 1 decimal. I want to add data validation to that cell so that it only allows between 0% and 100%. I set up some data validation to allow decimal between 0 and 100. When I type a number in that cell, such as 344, it automatically adds the % sign to the end and it allows that number. Is there a way to fix this?
Bookmarks