Data Validation

  • Thread starter Thread starter ASPENCO
  • Start date Start date
A

ASPENCO

I am attempting to limit the input of a cell to between zero and on
hundred percent. The cell is formatted for percent. I have tried th
validation using both "custom" and "decimal" and in both cases after
enter an invalid entry and "retry" the cell is reformatted so that if
enter "20" it appears as "2000%" instead of "20%". Thanks for you
help. Happy Holidays
 
The cell isn't reformatted. But unless you use an event macro, I
don't think there's a way to bypass this design. The Retry appears
to bypass the editor's adding a percent sign at the end, just as if
you deleted it when making an entry.

An event macro might look at the entry, and if it's greater than 1
and less than 100, divide by 100. However, that would still leave
you vulnerable to entering a value by mistake, then trying to enter,
say, "0.5" and have the parser evaluate it as 50% rather than 0.5%.
 
Back
Top