The following are some number formats that can be used with the setNumberFormat() and setNumberFormats() methods provided in Google Apps Script: Currency: $#,##0.00;$(#,##0.00) Date: M/d/yy These were not obvious in the documentation and I pulled them usin gthe "getNumberFormats()" method.