How can Excel generate more decimal points ie 5.5% not 5%
 

I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
and not just 5%. How can I do this?

How can Excel generate more decimal points ie 5.5% not 5%
 

I guess it depends on what's in B8 and C8

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"helpmeplease" wrote in message
...
I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
and not just 5%. How can I do this?

How can Excel generate more decimal points ie 5.5% not 5%
 

Format the cell. Right click on the cell, choose Format Cells..., go to the
Number tab, and specify the number of decimal places.

--
Regards,
Fred


"helpmeplease" wrote in message
...
I need excel to calculate a simple formula (=(B8-C8)/C8) to give me 5.5%
and not just 5%. How can I do this?