Excel 97 Validation

  • Thread starter Thread starter craigl
  • Start date Start date
C

craigl

I have cell formatted for percent and would like to validate the same
cell to enter a whole number between 1 and 100. I want an input to be
in whole numbers with the operand and displayed as 85%. The problem
is entering a value of 85 yields 8500% due to the format of the
operand. I am also using this cell in a formula in another cell. I
then changed the validation to decimal between .01 and 1. This works
fine except now the input has to be .85 for 85% (Although I discovered
it works fine if you do not go out the range at first. You can
repeatedly enter whole numbers until a number is entered outside of
the validation. Once a value of 101 is entered my error message alert
prompts to enter a value between 1% and 100%. If you enter a value of
85, the error message is displayed. You then have to enter .85 to get
85%.). I would like for the input to be 85 to get 85%, but to remain
as a value of .85 for later calculations. So in conclusion I would
like to know how to set up the cell for an input of a whole number
with operand % displayed and be able to functionally use 85% as .85 in
later calculations.
 
Craig,

I have Excel 2002, but I don't think this is different from Excel 97.

The number format "0%" (without the qoutes) gives the result you want, i
beleive.

Entering 85 displays as 85% and counts as 0.85.

Entering .85 displays as 85% and counts as 0.85.

Entering 0.85 displays as 1% and counts as 0.0085

HTH
Anders Silvén
 
Back
Top