percentage

C

cj

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
 
B

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)
 
C

cj

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

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?
 
G

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
 
G

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
 
Top