2

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.

Improve this question
5
  • 2
    Possible duplicate of Leading zeros in Google Spreadsheet automatically removed
    – Rubén - Volunteer Moderator - ♦
    Commented Jan 25, 2017 at 2:14
  • @Rubén It appears this question is about trailing zeros, despite its title.
    – user135384
    Commented Jan 25, 2017 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 - Volunteer Moderator - ♦
    Commented Jan 25, 2017 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
    Commented Jan 25, 2017 at 2:32
  • @zaq: Would you like to improve the question?
    – Rubén - Volunteer Moderator - ♦
    Commented Jan 25, 2017 at 2:35

2 Answers 2

Reset to default
2

In order to keep trailing zeroes of 1 to the 1.0 you just have to klick "Increase Decimal Place"

In order to remove trailing zeroes of 1.0 to the normal 1 you just have to set the number format back to "Automatic"

Improve this answer
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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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