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

May 2019
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