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.
