formula for fraction, can convert from percentage if need be

[dtm_1986]

I have an internet usage document and have a fraction column for each region of the world and a percentage and decimal columns.

I would like a formula that will give the answer in a fraction (we have to have many diffrent methods of displaying the data e.g. fractions decimals percentages)

i already have the answers in percentage and decimals so i know you can convert percentages to fractions but i dont know the formula??? ? ? ? ? ? ? ? ? ? ???

 

[Andrew Poulsom]

Right click the cell, choose Format Cells, click Fraction on the Number tab and choose the Type you want.

 

[GlennUK]

It's just a matter of using the %age figure and then applying the fraction number format ( menu command Format/Cells/Number/Fraction ).