I've been able to restrict the value of cells to drop down values, whole numbers, dates, etc. I'm trying to restrict the value of cells to a percentage. I don't see percentage as a value for 'Data Validation'.
Is there a way to restrict the entry of a value of a cell to a number percentage? For example, I want the user to only be able to enter a number. When that number is entered it's shown as a percentage.
Thank you!
Is there a way to restrict the entry of a value of a cell to a number percentage? For example, I want the user to only be able to enter a number. When that number is entered it's shown as a percentage.
Thank you!
