You can also choose how many decimal places appear in cells that contain numbers, currency units or percentage values, even if the exact value entered in the cell has more decimal places than you want to show. The actual value entered is always the value used in calculations, regardless of how many decimal places appear in the cell. If a formula refers to text in a cell, the displayed value is used in the calculation.