title: Apps Script : Custom number format with text
body: <p>I'm trying use google apps script to format a range of cells in google sheets.  The cells currently have a number in them like &quot;1000&quot;, and I want them to be formatted like &quot;1,000 lbs&quot;.  I know in sheets you can use the custom number formatting and simply use &quot;###,0 lbs&quot; to get the desired outcome.  However, I need it to work in google apps script.  Also, I don't want to just add a string &quot; lbs&quot; to the number, I want the range to be formatted with &quot; lbs&quot; in it.</p>
  <p>I thought I could use the method setNumberFormat(&quot;#,##0 lbs&quot;) in the Range Class, but it displays the error message &quot;Service Error: Spreadsheets&quot;.  Please Help</p>