The other answer, to set the format to ‘plain text’ in javascript, doesn’t work. However, this does:
sheet.getRange(1,n).setNumberFormat('@STRING@');
So the magic value for formatting text programmatically is ‘@STRING@’!
The other answer, to set the format to ‘plain text’ in javascript, doesn’t work. However, this does:
sheet.getRange(1,n).setNumberFormat('@STRING@');
So the magic value for formatting text programmatically is ‘@STRING@’!