Displaying percentage sign in cell

[Guest]

We want to have a cell show just the numerica value of the percentage. I.e.
if it is .07 and displays as 7%, we just want the 7 to display. How do we
format the cell to do that? We've tried all of the format choices that would
apply to numbers.

 

[Peo Sjoblom]

If these are typed in values why don't you just type in 7 and format as
general, if you need to do calculations you can always divide it by 100 in
the formula, or if it is a result of a calculation just multiply it with 100
and format as general

 

[Guest]

It's a huge spreadsheet and we didn't want to spend the time retyping
everything! Thanks for your suggestion, though!

 

[Roger Govier]

Hi

One way
Enter 100 in a blank cell. Copy the cell.
Mark the range of cells concerned, Paste Special>Multiply

Note this will turn any formulae into (original_formula)*100