title: Excel number formatting. Treat my cell as a number but leave its formatting alone! (ie Trailing 0's)
body: <p>I have (what seems like it should be) a simple problem.  I need to be able to tell excel (in vba) that a cell's contents are numeric, but I don't really want to apply any formatting to it.  I need my trailing zeros left how they are.  Am I missing something incredibly simple?</p>
  
  <p><strong>Update:</strong></p>
  
  <p>I'm getting xml data from a query and am placing it into the spreadsheets.  But lets say one of the cells has <code>589.950000</code> I need to keep those additional zeros on display for the user (don't ask me why, they just want the precision) but excel converts it to <code>589.95</code>.  I also need for them to be able to do spreadsheet calculations on that cell (so I can't format it as text).</p>
  
  <p><strong>Update 2:</strong></p>
  
  <p>Further Clarification.  Lets say I have 4 values that I'm going to place into a column</p>
  
  <pre><code>595.56000
  15.00
  90.00050
  1919.120000000
  </code></pre>
  
  <p>is there one numeric format that I can apply to that column that will display those exact numbers?</p>