Excel Data Validation. I need the input in the box to be limited to a % with 2 whole #s and 2 decimals. How?

I'm an administrative assistant at a small company and I am the excel go-to. My manager needs a worksheet that includes a column for profit %. The column is already formatted to automatically make the input into a percentage. However, I need to specify that the input can only have 2 whole numbers, then 2 decimal places. I'm having difficulties with this, as data validation isn't my strong point. Any helpful suggestions are much appreciated.Excel Data Validation. I need the input in the box to be limited to a % with 2 whole #s and 2 decimals. How?
2 whole numbers and 2 decimal places?


the 2 decimal places makes sense.





i read that as any number less than 100. so up to 99.99


what about 1 whole number? like 8.57 i will assume thats ok, because its really the same as 08.57





- highlight your range of cells (i have to assume you start at cell A1)


go back into data validation


- in the allow box choose custom


- in the formula box paste this





=A1=IF(A1%26lt;100,INT(A1*100)/100,FALSE)





if you really want %26gt;=10 or you can change the 10 to a 0 for only positive #'s





=A1=IF(A1%26lt;100, IF(A1%26gt;=10, INT(A1*100)/100, FALSE),FALSE)





just change A1 to whatever cell you start at.





edit-


oops if you formatted the cells as a %, then





=A1=IF(A1%26lt;1, INT(A1*10000)/10000,FALSE)





where typing 54.44 shows up as 54.44%