Tip: The number that is in the active cell of the selection on the worksheet appears in the Sample box so that you can preview the number formatting options that you select. On the backstage screen, click “Options” in the list of items on the left. To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Select the cells that you want to format.For example, a 2-decimal scientific format displays 1 as 1.23E+10, which is 1.23 times 10 to the 10th power.įollow these steps to apply the scientific format to a number.
Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 The Scientific format displays a number in exponential notation, replacing part of the number with E+ n, in which E (exponent) multiplies the preceding number by 10 to the nth power.
0 kommentar(er)
