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

October 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