Decimal Places in Excel - AdvantEdge Training & Consulting

Decimal Places in Excel

By default, Excel shows the number of decimal places that can comfortably fit in a cell. If the cell is narrow, it might only fit one or two. A wider cell can fit many more.
Sometimes, however, I want to show more or fewer decimal places. Making this change is easy to do.
decimals in excel

    • Right click on the cell you want to change, or select several different cells by first left clicking and dragging, then right clicking on the selected group.
    • The first button with the arrow pointing left adds decimal places. The next button with the arrow pointing right, hides them. Choose whichever you like.
    • Click on an empty part of the page to continue working on your spreadsheet.

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top