function formatColumnAsText() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Assuming you want to format column A as text var columnToFormat = "A"; var range = sheet.getRange(columnToFormat + "1:" + columnToFormat); // Set the number format of the range as plain text range.setNumberFormat("@");
}