title: How to format Microsoft Excel data labels without trailing decimal on round values?
body: <p>(Not sure if this is the best stack for this question).</p>
  
  <p>What is the format to have 14500 read as $14.5K but to have 3000 read as just $3K without the trailing decimal point?
  I can't seem to comprehend the correct expression from the <a href="http://office.microsoft.com/en-au/excel-help/create-a-custom-number-format-HP010342372.aspx" rel="nofollow noreferrer">manual</a>.</p>
  
  <p><img src="https://i.stack.imgur.com/t0IXh.png" alt="enter image description here"></p>