Home » Questions » Computers [ Ask a new question ]

How to limit the number of decimal places in an Excel spreadsheet?

How to limit the number of decimal places in an Excel spreadsheet?

For example, I'll have Excel calculate a value based on two other cells, and then have it displayed in another. This is working fine, but how would I limit the number of decimal places it shows?

Asked by: Guest | Views: 84
Total answers/comments: 2
Guest [Entry]

"Select the output cell, right click and select ""Format Cells...""

Select the ""Number"" tab and then ""Number"" in the list.

Set the ""Decimal places"" value to the desired value."
Guest [Entry]

"Another option would be to use the round function.

=Round(1234.5678, 2) would yield 1234.56
=Round(1234.5678, 0) would yield 1234
=Round(1234.5678, -2) would yield 1200

Wrap this around your other calculation and you can control not only how it displays, but the accuracy of the number if it is used by another function later on. This becomes important when trying to use Excel to manage money where the number of decimal places is fixed and calculations should all be to that same level of precision."