You are dealing with a returned number < 1 when you divide say 143 by 200.

The returned value is .715

Multiplying by 100 is only method AFAIK

No Custom Format that I know about.

But I am eager to learn<g


Gord Dibben MS Excel MVP


On Tue, 25 Aug 2009 13:34:01 -0700, darby
wrote:

I have a simple formula in one cell, dividing A1 into B1 and I cannot find
the correct formatting to have it read correct e.g. 71.5 The closest I get
is either 71.5% or .715. I can obviously multiply the cells by a 100 but it
seems Excel should have the above fomatting option - am I wrong?

Thanks