Posts

Showing posts with the label Fraction Format

Fraction Format in Excel

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