Help

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

1054 0
cancel
Showing results for 
Search instead for 
Did you mean: 
immeasurablemat
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2

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!)