Trying to set format for worksheet to accept zip codes into cell. Unfortunately when trying to do this it doesn't accept the leading zero. How can I set the custom format into my code.
Here is an example of my code.
var zipFormat = [
["00000", "00000"],
];
var numberRange = sheet.getRange("C2:D1048576");
numberRange.numberFormat = zipFormat;