Displaying zeroes in decimals

  • Thread starter Thread starter patrickcnj
  • Start date Start date
P

patrickcnj

I need to display numbers like "1.0" and 2.0" and I can't get around the
auto-correct that changes them to "1" and "2". How do I do this? Thanks!
 
You should see a comma style button on your formatting toolbar. It's next to
the dollar button and the percentage button. Click that and your numbers
will be formatted with 2 decimal places. Use th two buttons next to that to
increase or decrease the number of decimal places.
 
You could also use a Number format and specify the number of decimal places you
wanted to see.
 
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

Decimal point in bar chart and similar 1
Zeros after the decimal 7
office 2003 Excel - SUM 3
Fixed Decimals in Excel 2007 4
Decimal 1
Concatenate Displays Too Many Decimals 2
Displaying zeros in cells 2
Automaticallychanging the number of decimal places displayed 5

Back
Top