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

H

helpmeplease

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?
 
P

Peo Sjoblom

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
 
F

Fred Smith

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