{"id":3827,"date":"2019-01-02T17:05:53","date_gmt":"2019-01-02T17:05:53","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3827"},"modified":"2024-03-26T12:56:34","modified_gmt":"2024-03-26T12:56:34","slug":"e-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/e-in-excel\/","title":{"rendered":"E in Excel"},"content":{"rendered":"\n
While working with Excel, you may have noticed that sometimes the letter E<\/strong> appears in the calculation. In some cases, after the letter E<\/strong> there was a positive number, and sometimes a negative one.<\/p>\n\n\n\n This is called scientific notation<\/strong>. Excel uses this notation to display a result in a shorter form, otherwise, it would have to display only part of a number as it does with text.<\/p>\n\n\n\n When Excel displays a number in scientific (exponential) notation, it means that it takes part of a number before E and multiplies it by 10 to the power of a number after E.<\/p>\n\n\n\n Here\u2019s a simple example to illustrate it.<\/p>\n\n\n\n 123,456,789 = 1.23 * 10^8<\/p>\n\n\n\n The number will stay the same, but it will show it in a shortened, less precise form. So when you write the formula = 1.23 * 10^8<\/strong> it will display it as 123,000,000.<\/p>\n\n\n\n But you can also find less precise notations:<\/p>\n\n\n\n =1.2 * 10^8 (120,000,000)<\/p>\n\n\n\n =1*10^8 (100,000,000)<\/p>\n\n\n\n It all depends on the amount of space you have inside your cell.<\/p>\n\n\n\n Let\u2019s take a look at a practical example in Excel.<\/p>\n\n\n\nWhat does scientific notation do?<\/h2>\n\n\n\n