# Google App Script

**URL:** https://community.glideapps.com/t/google-app-script/49745
**Category:** Ask for Help
**Tags:** custom-code
**Created:** [September 20, 2022, 11:34pm UTC](https://community.glideapps.com/t/google-app-script/49745 "2022-09-20T23:34:12Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ideapps/32/42628_2.png) [@IDEApps](https://community.glideapps.com/u/IDEApps)
#### Post date: [September 20, 2022, 11:34pm UTC](https://community.glideapps.com/t/google-app-script/49745/1 "2022-09-20T23:34:12Z")

</div>

Hi Gliders,

I just wanna share one of Google App Script of mine to set up date and number on single column. I hope it’s useful for the low-code beginners like me 😀

It’s just my two cents 🙌🏼

#Format Number and Date#

function formatNumberDate() {

//sheet name  
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“your sheet name”);

// Single column  
var column1 = ss.getRange(“your targeted column”);  
var column2 = ss.getRange(“Y2:Y”);

//date format  
column1.setNumberFormat(“d-mmm-yyyy”);

//number format  
column2.setNumberFormat(“Rp#,##0;Rp(#,##0)”);

}