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