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

[immeasurablemat]

When I try to convert a # field to a % field, Airtable adds like two decimal points - any idea why and how to undo this?

[kuovonne]

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.

[immeasurablemat]

Thanks so much @kuovonne! (again!)