In this case a date format:
1 2 3 4 5 6 7 |
function setDateFormat() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var db = ss.getSheetByName("Form responses 1"); SpreadsheetApp.setActiveSheet(db); var range = ss.getSheetByName("Form responses 1").getRange("N"+1 + ":N"); range.setNumberFormat("dd/MM/yyyy"); } |