Converting # field to % field adds 2 decimal places - how to fix?

When I try to convert a # field to a % field, Airtable adds like two decimal points - any idea why and how to undo this?
Screen Shot 2020-09-23 at 5.55.32 PM
Screen Shot 2020-09-23 at 6.00.13 PM

The value of the underlying number is not being changed. This is part of the general relationship between decimals and percents.

A value of 96% would be a decimal number of 0.96.
Thus the number 96 would be 9600%.

You can use a formula field to divide the numbers by 100 and then copy the new values back to the percent field.

1 Like

Thanks so much @kuovonne! (again!)

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.