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

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

Dave
--
Brevity is the soul of wit.


"Stan Atshuller" wrote:

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

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


"Stan Atshuller" wrote in message
...
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

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


"Stan Atshuller" wrote in message
...
|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
|
|