Data Validation

  • Thread starter Thread starter LAF
  • Start date Start date
L

LAF

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?
 
I think you need to limit your input to numbers between 0 and 1.0
(100%=1)

Then an entry keyed in as "99" will return 99%

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation? 2
Data Validation 4
Validation of Percentages Does Not Appear To Work 1
Locking Cell dependent on Another Cell Value 7
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Number validation 13
Data Validation error (XL2003 and XL2007) 1
DATA VALIDATION 3

Back
Top