google-apps-script Changing column format

Question

need to format columns c, e and a few others to show the date using the format below:

4 July 2014

Can't work out how to do it ... new to google script!

HDCerberus · Accepted Answer · 2014-12-21 14:41:23Z

13

To do this using Apps script, you can use the setNumberFormat(numberFormat), which lists that date formats follow the SimpleDateFormat specification.

Sample code that will do this:

function formatDate(){
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getActiveSheet();
  sheet.getRange("A2").setNumberFormat('dd MMM yyyy');
};

answered Dec 21, 2014 at 14:41

HDCerberus

2,1634 gold badges22 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

google-apps-script Changing column format

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related