A participation report has a column of numbers like 25. Read the source heading and formula bar to determine whether the entry is a count, a whole-number percent, or a fraction.

Build the share from its numerator and denominator

With 25 registrations in B2 and a total of 100 in C2, enter =B2/C2 and apply Percent in Ulet. Expect 25%. Applying the same format directly to the number 25 displays 2500%.

Two underlying numbers produce very different displays under the same format.

Illustrated distinction between scale and display.

Check the scale before converting a whole column

On a scratch copy use General to inspect the stored value. Multiply 0.25 by 100 to recover the 25 registrations. If the source stores percentages as whole numbers, divide by 100 in a separate column after confirming the convention. Leave ordinary counts in their original units.

25 registrations out of 100 produce the stored fraction 0.25 and display 25%.

Illustrated share from known counts.

Related Microsoft Excel reference