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

April 2018
M	T	W	T	F	S	S
« Feb
						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