0

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.

  • 2
    Possible duplicate of Leading zeros in Google Spreadsheet automatically removed – Rubén Jan 25 '17 at 2:14
  • @Rubén It appears this question is about trailing zeros, despite its title. – user135384 Jan 25 '17 at 2:18
  • @zaq: The point is that spreadsheets handle values in a different way than databases, almost all values that looks like a number are treated as numbers and the default number formatting is applied by default :) – Rubén Jan 25 '17 at 2:22
  • @Rubén I don't see this being an answer in the linked post. Moreover, this question is about form submission, which takes the accepted answer "format the cell as plain text" out of the picture - form submission creates new cells with default formatting. – user135384 Jan 25 '17 at 2:32
  • @zaq: Would you like to improve the question? – Rubén Jan 25 '17 at 2:35
0

Basically this question is about how to format form responses submitted to Google spreadsheet

A form submission inserts a new row at the end of the sheet data range and this new row inherits the defaults number format settings.

Things to try:

  • Apply the desired format to the whole column not just to cells that actually contain data.
  • Delete all the blank rows below the data range
  • Use script to format the newly inserted row or the whole data rage.

The related questions have answers that include scripts that could help you as a starting point.

Related

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.