Displaying percentage sign in cell

F

Feather 52

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.
 
P

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
 
F

Feather 52

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

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
 
Top