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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Format the cell. Right click on the cell, choose Format Cells..., go to the
Number tab, and specify the number of decimal places.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for showing warnings when cells are out of range. 1
LOOOONG if statement out of room, need help to shorten 4
Excel Excel Formula - IF Function with percentages 1
Macro Adding Numbers in Column A + B = C 8
Some results that I do not want to Print 2
Formulas Aren't Automatically Updating When Cells Change 5
Function 6
Use a wildcard within edit/replace 4

Back
Top