Displaying percentage sign in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Feather 52 - 12 Jun 2007 17:06 GMT

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.

Reply to this Message

Peo Sjoblom - 12 Jun 2007 17:13 GMT

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

Signature

Regards,

Peo Sjoblom

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

Reply to this Message

Feather 52 - 12 Jun 2007 17:22 GMT

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

> 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
[quoted text clipped - 7 lines]
> > would
> > apply to numbers.

Reply to this Message

Roger Govier - 12 Jun 2007 18:46 GMT

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

Signature

Regards

Roger Govier

> It's a huge spreadsheet and we didn't want to spend the time retyping
> everything! Thanks for your suggestion, though!
[quoted text clipped - 16 lines]
>> > would
>> > apply to numbers.

Reply to this Message