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

February 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