Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 4 down vote accepted

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.

alt text

share|improve this answer
+1. Or what ever number you want. You can also select a group of cells and set them – Xavierjazz Jan 30 '10 at 22:49
Much appreciated! – AtomFury Jan 30 '10 at 22:49
@Xavierjazz - indeed, I've corrected the post. I don't know why I assumed the OP wanted 2 dp. – ChrisF Jan 30 '10 at 22:51
this is correct – at. Jan 30 '10 at 23:57

There should be two buttons on toolbar to increase and decrease number of decimal places displayed:

excel decimal size buttons

share|improve this answer

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.

share|improve this answer

Use the round function:

share|improve this answer
This was already suggested here with quite a bit more detail. – Oliver Salzburg Mar 26 '13 at 13:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .