Percentages in Excel

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

Guest

Why can't I use 7.5%? Excel keeps reinserting 8% into the cell. How can I
insert less than whole numbers?
 
Check that the cell formatting has sufficient decimal places for
percentages.

Ian
 
Go to:

Format / Cells / Percentage / Decimals places (and fix decimals to an
place you want to
 
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

Nested If functions and Formulas 5
in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours 1
Imported data 1
if/and...not quite sure 3
Excel Can a pie of pie chart use animation/transitions? 1
Excel Average dates help 0
Excel turning percentages into scientific notation 2
Percentages 2

Back
Top