Scientific Format in Excel
In this blog post we will learn in detail about “Scientific Format in Excel”. There are many instances when we need to convert numbers in scientific format while working in excel. If we can learn to use “Scientific Format in excel” wisely, then we can work very effectively while dealing with such values in excel. This format will display number in “Exponential Notation” in E+n format where E is considered as base of the number and n is considered as power of that number. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values. If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Scientific” Category as shown in below image. With this we can see all the additional options under “Scientific Format in excel” as shown in below image: Sample : This option is common in all the formats which we can see under Scienti...