When I submit a google form field with a value of 0.0 or 1.0, the 0 after the decimal is omitted in the spreadsheet results. When I submit number other than trailing zero, e.g. 1.5 , it posts fine as 1.5 in the spreadsheet.

I tried to select and preformat blank cells (Format->Number) in the spreadsheet where these trailing zeros would appear, but Google is not saving the number formatting on blank cells. It defaults to Automatic.

Any suggestions how to stop spreadsheet from removing the trailing zeros? Right now I have to add them manually.

When I submit a Google form field with a value of 0.0 or 1.0, the 0 after the decimal is omitted in the spreadsheet results. When I submit number other than trailing zero, e.g., 1.5 , it posts fine as 1.5 in the spreadsheet.

I tried to select and preformat blank cells (Format->Number) in the spreadsheet where these trailing zeros would appear, but Google is not saving the number formatting on blank cells. It defaults to Automatic.

Any suggestions how to stop spreadsheet from removing the trailing zeroes? Right now I have to add them manually.

When I submit a google form field with a value of 0.0 or 1.0, the 0 after the decimal is omitted in the spreadsheet results. When I submit number other than trailing zero, e.g. 1.5 , it posts fine as 1.5 in the spreadsheet.

I tried to select and preformat blank cells (Format->Number) in the spreadsheet where these trailing zeros would appear, but Google is not saving the number formatting on blank cells. It defaults to Automatic.

Any suggestions how to stop spreadsheet from removing the trailing zeros? Right now I have to add them manually.

Thank you.

When I submit a google form field with a value of 0.0 or 1.0, the 0 after the decimal is omitted in the spreadsheet results. When I submit number other than trailing zero, e.g. 1.5 , it posts fine as 1.5 in the spreadsheet.

I tried to select and preformat blank cells (Format->Number) in the spreadsheet where these trailing zeros would appear, but Google is not saving the number formatting on blank cells. It defaults to Automatic.

Any suggestions how to stop spreadsheet from removing the trailing zeros? Right now I have to add them manually.