Format a Google Sheets cell in plaintext via Apps Script

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@’!

Leave a Comment

tech