title: Setting column in Google Sheets API (with Python) to be number-formatted
body: <p>I'm trying to format a column of numbers in Google Sheets using the API (Sheets API v.4 and Python 3.6.1, specifically). A portion of my non-functional code is below. I know it's executing, as the background color of the column gets set, but the numbers still show as text, not numbers.</p>
  
  <p>Put another way, I'm trying to get the equivalent of clicking on a column header (A, B, C, or whatever) then choosing the Format -> Number -> Number menu item in the GUI.</p>
  
  <pre><code>def sheets_batch_update(SHEET_ID,data):
      print ( ("Sheets: Batch update"))
      service.spreadsheets().batchUpdate(spreadsheetId=SHEET_ID,body=data).execute() #,valueInputOption='RAW'
  
  data={
    "requests": [
      {
        "repeatCell": {
          "range": {
            "sheetId": all_sheets['Users'],
            "startColumnIndex": 19,
            "endColumnIndex": 20
          },
          "cell": {
            "userEnteredFormat": {
              "numberFormat": {
                  "type": "NUMBER",
                  "pattern": "#,##0",
              },
              "backgroundColor": {
                "red": 0.0,
                "green": 0.4,
                "blue": 0.4
              },
            }
          },
          "fields": "userEnteredFormat(numberFormat,backgroundColor)"
        }
      },   
    ]
  }
  sheets_batch_update(SHEET_ID, data)
  </code></pre>