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

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


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

excel decimal size buttons