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.
Leading zeros in Google Spreadsheet automatically removed from form submission
google spreadsheets;google forms