Mike

In F1 enter =E1/14 and format as percentage.

If the 14 will change over time, you could enter that number in a cell(say A1)
and refer to the cell.

=E1/A1


Gord Dibben Excel MVP

On Fri, 21 Jan 2005 15:45:02 -0800, "Mikewoodmsw"
wrote:

I want to convert a test score to a percentage, however the fraction may
change

e.g. column E displays scores which are out of 14. How do I have that
displayed in column F as a percentage?