Send to a Friend

bootonthroat's avatar

How do I get OpenOffice Calc to format 69% as 69% instead of 6900%?

Asked by bootonthroat (344points) June 30th, 2010

Imagine you have a column APR and in it you have the value “3.5”. How do I display a percent sign after the 3.5? I can only figure out how to display numbers which are NOT percentages with a % such as 0.035. Notice 0.035 is NOT a percentage but will display as 3.5% when converted to one. I already have the numbers as percentages. It doesn’t seem unreasonable that I should want to display a % sign after a percentage but it does appear impossible as far as I can determine.

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.