Excel Tricks with Tejraj

In this blog post we will learn in detail about “Text Format in Excel”. There are many instances when we need to convert numbers in “Text Format”. There are some advantages as well as some drawbacks of this “Text Format in Excel”. We will learn all these things in detail in this blog post. 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 “Text” Category as shown in below image. With this we can see all the additional options under “Text Format in excel” as shown in below image: Sample : In this field we can see how our output will look like. We can see the sample output of the value which we are going to convert in “Text Format”. First we will see how we can convert the number into “Text Format” with simple example. 1. We hav...

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...

In this blog post we will learn in detail about “Percentage Format in Excel”. There are many instances when we need to convert numbers in percentage format while working in excel. If we can learn to use “Percentage Format in excel” wisely, then we can work very effectively while dealing with percentage in excel. 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 “Percentage” Category as shown in below image. With this we can see all the additional options under “Percentage Format in excel” as shown in below image: Sample: This option is common in all the formats which we can see under Percentage Category in above image which we can use to see how the selected numbers will look in Percentage Format. Decimal Places: With this we c...

In this blog post we will learn in detail about “Fraction Format in Excel”. There are many instances when we need to use numbers in fraction format in excel. If we can learn to use “Fraction Format in excel” wisely, then we can work very effectively while dealing with fractions in excel. 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 “Fraction” Category as shown in below image. With this we can see all the additional options under “Fraction Format in excel” as shown in below image: Sample: This option is common in all the formats which we can see under Fraction Category in above image which we can use to see how the selected numbers will look in Fraction Format. Type: We can choose any of the fraction format under this option as per our requireme...