Abstract
Transcript
In this lesson we’ll look at the Fraction format.
The Fraction format is made to display fractions.
It can handle fractions of up to three digits, and comes with several presets for common fraction units.
Let’s take a look.
Let’s first copy these numbers to the rest of our table.
As we can see, Excel converts most of the values to fractions.
However, some numbers aren’t converted, while others are just a close match.
That’s the correct setting for column C.
For column D, we want fractions up to two digits.
For example, .97 was first expressed as 1, then as 32/33rds, then as 97/100ths.
Excel will display the best match available for each fraction format.
Let’s try quarters and eighths for the last two columns.
We’ll use the keyboard shortcut Ctrl-1 to get to Format Cells.
Again, we can see many fractions are estimates, while others are exact.
you might enter fractions directly in cells pre-formatted with the Fraction format.
You may want to adjust the fraction punch in in some cases.
you could work around this problem by entering a zero and a space first before the fraction.
For example, to enter four fifths, enter “zero space 4 / 5”
