Plan-B for OpenOffice.org & LibreOffice, learning office productivity software with videos
Tech Support for OpenOffice.org & LibreOffice

OpenOffice Tutorial: Format cell numbers into fractions

How-To: OpenOffice Tutorial: Format cell numbers into fractions
  1. You can actually change decimal figures to fractions easily within cells.
  2. To do this, move your mouse over one of the cells you want to format, then click and hold the left mouse button.
  3. Now, while holding the button, move your mouse towards the other cells you want selected.
  4. Once you have selected the cells you want, release the mouse button.
  5. Next, click here on "Format" and then on the menu that opens click on "Cells..."
  6. The format cells window should appear. If it is not open yet, click on the "Numbers" tab here.
  7. Then, on the Category list find and click on "Fraction"
  8. Afterwards, click on the fraction format you want.
  9. Once you're done click on OK.
  10. Great! As you can see the decimal numbers have turned into fractions.
  11. Congratulations! You have learned to format cells into fractions.

by

Show OpenOffice Tutorial: Format cell numbers into fractions

Format cell numbers into fractions

This screencast demonstrates how to format cell numbers into fractions. You learn:

Advanced topics

For advanced functionality with similar results see:

OpenOffice.org™ is a registered trademark of Oracle.
LibreOffice™ is a trademark of The Document Foundation.

Further questions?

*
*
*
*
* required fields