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%.

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.

Illustrated share from known counts.



