Excel formula - TechRepublic
General discussion
December 14, 2001 at 02:30 PM
micron39

Excel formula

by micron39 . Updated 24 years, 6 months ago

Hi,

I would like to ask, how I can write a formula on an excel worksheet column, in which I can enter a fraction and have it automatically converted to a percentage. The idea is to be able to set the whole column in order to change the fraction entered in any of that column’s cell, and have it changed to a percentage.
Example: say I enter 42/58 in cell G4, and 13/97 in G7, and 7/37 in G18, then have these fractions changed to their equivalent percentage. Please help and thanks in advanced.

This discussion is locked

All Comments