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?

+29

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.

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.

Thanks so much @kuovonne! (again!)

Sign up