GAS – format cell number format

In this case a date format:

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");
}

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");

}

METRIC RAT

Linux/Range Rover/MG/AppInventor/Google Apps Scripting

GAS – format cell number format

Leave a Reply Cancel reply

Follow METRIC RAT

December 2018
M	T	W	T	F	S	S
« May
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31