percentage

[Guest]

I need a formula to divide 2 numbers and return with a percentage with 2
decimals.
eg: 684/937 to return with 72.99%.

Thanks in advance

 

[Bob Phillips]

Just format (Format>Cells>Percentage) as % with two dec places.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Can't format cells, lost password to unlock work sheet.
Is there a manual formula you can enter in the cell?

 

[RagDyeR]

Try this:

=TEXT(A1/B1,"0.00%")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Can't format cells, lost password to unlock work sheet.
Is there a manual formula you can enter in the cell?

 

[Gord Dibben]

Just add the "=" sign to 684/937 to make it a formula.

=684/937 returns 72.99

Then format as Bob suggests.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

If the sheet is protected, how will you enter a formula in a cell, or is the
cell unlocked?

If the latter, see RD's response.


Gord

 

[Alan]

You can overcome the protection quite easily, If you aren't familiar with
code post back and you'll be talked through it by someone,
http://www.mcgimpsey.com/excel/removepwords.html
Regards,
Alan.