3

It looks like this issue is due to a bug in the new Google Sheets, but you can use this simple script as a workaround. In your sheet, go to Tools > Script Editor. Erase the existing code in Code.gs and add this instead: function setCellAlign(range, alignment) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell ...


1

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"


1

Create a "pivot table report" inside the Responses Sheet (Data → Pivot report table) in the "Report editor" on the left, insert the values of the Form as "Rows". format the columns as you like. How to create and edit a pivot table report in Google Sheets: https://support.google.com/docs/answer/1272900?hl=en


1

Follow these steps Open the Google Spreadsheet file that your form responses are saved into. Select the whole column, by clicking on the column name letter at the top of it - not just a set of rows in it. Apply the alignment you want. Your selected alignment should now be applied to all new rows that are added to the Sheet from the Form. (I have just ...


Only top voted, non community-wiki answers of a minimum length are eligible