Form value of 1 in percentage column captured as 1% not 100%

Options

I have a form that captures data in a column with percentage formatting applied. If a decimal value is selected such as .5 the data is properly captured in the sheet at 50%, but if 1 is selected it is captured ad 1%, not 100%. I've tried to change the value to 1.0 and 1 and the behavior is the same. In the sheet itself if I choose 1 from the value dropdown it is properly adjusted to 100%, only data entered via the form is incorrect.

Tags:

Answers