Format % Question

[Stan Atshuller]

I have a number in percent format 5% I need it to be displayed as 5 with out
changing the formula. Excel multiplies by 100 and then add the % sign, I
need it to multiply by 100 and not add the % sign.
Is this possible?
Thanks!
Stan

 

[Guest]

Well 5% = .05. How do you propose changing 5% to 5 without multiplying?

Dave

 

[Bernie Deitrick]

Stan,

Formatted for 0 decimals:
=A1*100

or if you need to use it in a string:

="The percentage is " & TEXT(A1*100,"0") & "."

HTH,
Bernie
MS Excel MVP

 

[Ponty'NPop]

Perhaps,

In a separate cell/column, type the whole number i.e. 5
say cell A1

Link the percentage cell to the 'display' cell above and
divide by 100 i.e A1/100.

You may then hide the percentage cell, if not required.

HTH,
--
Kevin James.
Tua'r Goleuni


|I have a number in percent format 5% I need it to be displayed as 5 with out
| changing the formula. Excel multiplies by 100 and then add the % sign, I
| need it to multiply by 100 and not add the % sign.
| Is this possible?
| Thanks!
| Stan
|
|