title: Round variable in Javascript Google Spreadsheet
body: <p>I am querying a Google Spreadsheet and the number I am getting is blowing up some weighting I am doing further down in the code.</p>
  
  <p>My query:</p>
  
  <pre><code>function queryValue3(met1,met2,met3) {
  var query3 = new google.visualization.Query('https://spreadsheets.google.com/spreadsheet/tq?range=B7:B9&amp;key=my_key&amp;gid=10');
  query3.send(function (response) {
      if (response.isError()) {
          alert('Error in query3: ' + response.getMessage() + ' ' + response.getDetailedMessage());
          return;
      }
  
      var data3 = response.getDataTable();
  
      var m1 = data3.getValue(0, 0);
      var m2 = data3.getValue(1, 0);
      var m3 = data3.getValue(2, 0);
  </code></pre>
  
  <p>The number I'm pulling for m2 is apparently 25.3333333333333323 and is blowing me up later in the function.  As long as my numbers are rounded to the 10th or 100th (in this case I want 10th) the function works fine.  I using the custom round (1 decimal) and it looks correct in the sheet but the query is grabbing the raw number?  In most cases my number is whole and I want it to not have a decimal in those instances.  Can someone help me modify the variable m1, m2, and m3 for this case?</p>
  
  <p>Thanks...</p>