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

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

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