title: Excel 2007 Number with no decimals but not Auto-Rounded?
body: <p>I seem to be having a fairly straightforward issue with Excel, although I cannot find a solution to it besides including a function.</p>
  
  <p>Basically I would like to show a price in two fields, one for dollars and one for cents.</p>
  
  <p>I have this working fine but the issue that I have is when I put say <em>"24990.55"</em> in the dollars field it will show <em>"24991"</em> in dollars and <em>"55"</em> in the cents field.</p>
  
  <p>Is there any way I can force Excel to <strong>NOT</strong> Auto-Round?</p>