Numbers rounds the display value instead of truncating the display value. Set the number of decimal places: In the Decimals field, type the number of decimal places you want to display. Number: Displays standard number formatting. In the Format sidebar, click the Cell tab.Ĭlick the Data Format pop-up menu and choose an option: Select the cells or table you want to format. For example, if you change a cell with a number into a percentage, the number of decimal places displayed doesn’t change. You can change this setting so cells formatted as numbers display the same number of decimal places.Ĭhanges to decimal settings apply to both numbers and percentages.
By default, cells formatted as numbers display as many decimal places as you type in them.
