percentage
 

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

percentage
 

Just format (FormatCellsPercentage) as % with two dec places.

--
HTH

Bob

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

"cj" wrote in message
...
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

percentage
 

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

"Bob Phillips" wrote:

Just format (FormatCellsPercentage) as % with two dec places.

--
HTH

Bob

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

"cj" wrote in message
...
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

percentage
 

Try this:

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

HTH,

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


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

"Bob Phillips" wrote:

Just format (FormatCellsPercentage) as % with two dec places.

--
HTH

Bob

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

"cj" wrote in message
...
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

percentage
 

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


On Sat, 27 Oct 2007 16:06:02 -0700, cj wrote:

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

percentage
 

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

On Sat, 27 Oct 2007 16:20:00 -0700, cj wrote:

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

"Bob Phillips" wrote:

Just format (FormatCellsPercentage) as % with two dec places.

--
HTH

Bob

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

"cj" wrote in message
...
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

percentage
 

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.
"cj" wrote in message
...
Can't format cells, lost password to unlock work sheet.
Is there a manual formula you can enter in the cell?

"Bob Phillips" wrote:

Just format (FormatCellsPercentage) as % with two dec places.

--
HTH

Bob

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

"cj" wrote in message
...
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