title: Make excel only display two decimal places
body: <p>I've tried various things and nothing is working out quite like it should.  I've used the <code>office button, excel options, advanced, and set the automatic insert decimal place to 0'.</code>  <code>Then I tried the format cells, and set the decimal places to 2</code> method.  Nothing gives me what I want.  I either end up with whole numbers with two decimal places e.g. 23.00 or when i enter 5.23 into a cell I only get '23' showing up.  </p>
  
  <p>Is there a way to show whole numbers without decimal places and have excel never show more than 2 decimal places in non-whole numbers?</p>