title: Limiting SQL Results to 2 Decimal Places in Excel
body: <p>I have this very simple SQL query running in Excel:</p>
  
  <pre><code>SELECT "DCNR 595 C 24H|Well Based|Desc Run Depth|MWD_STEM|EM Temperature".Temperature
  FROM ADI."DCNR 595 C 24H|Well Based|Desc Run Depth|MWD_STEM|EM Temperature" "DCNR 595 C 24H|Well Based|Desc Run Depth|MWD_STEM|EM Temperature"
  </code></pre>
  
  <p>And I would like to limit the output to two decimal places, rounding up as appropriate, instead of just truncating the result. So I have a series of results like this: 147.20 instead of 147.19999694824 in the Excel report.</p>
  
  <p>I have tried CAST and ROUND functions, without success, but I am also struggling doing this inside of Excel. The MS Query application doesn't seem to like anything I do. :(</p>
  
  <p>(Note: I cannot just format the Excel cells to show only 2 decimal places. The actual returned values have to be 2 decimal places.)</p>