// Select all rows and columns from a spreadsheet var range = sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()); // Money format range.setNumberFormat("$#,##0.00;$(#,##0.00)");