Excel: Formatting Numbers – Decimal Places

Whether you have entered some numbers into Excel or have numbers based on calculations from functions or formulas it may be that it is showing too few or too many decimal places. This can easily be fixed using some buttons on the toolbar or ribbon depending on the version of Excel you have.

You may also want all the numbers to have the same number of decimal places.

Here is how you can set the decimal places.

One thought on “Excel: Formatting Numbers – Decimal Places

Comments are closed.