Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Fraction Format

If you enter a decimal number in a cell, Excel can format it as a whole number and a fraction.  There are various options available and if you choose a unit such as quarters, Excel will display the number to the nearest quarter.  If you use an option like ‘up to three digits’, Excel will convert the number to the nearest fraction it can up to 1/999.

 

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk