Did you try formatting it Number with Decimal Places = 1?

It sounds like the result of your calculation is .715, and you can't really
get excel to display that as 71.5

"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