Understanding Number Formats

Number formatting tips

Here are a few tips for getting the best results with number formatting.

Increasing and decreasing decimals

The Increase decimal places and Decrease decimal places commands allow you to control how many decimal places are displayed in a cell. These commands don't change the value of the cell; instead, they display the value to a set number of decimal places.

The Increase and Decrease Decimal commands

Decreasing the decimal will display the value rounded to that decimal place, but the actual value in the cell will still be displayed in the formula bar.

The number may display rounded

The Increase/Decrease decimal places commands don't work with some number formats, like Date and Fraction.