title: How to format cells as weight in grams but removing insignificant decimal point and places?
body: <p>I have a sheet with values that I want to format in grams. The values range from high to low and I wish to format them with a comma as a thousand-separator, and rounded to two decimal places, but trimming both the decimal point and places where the number is a whole number. The following examples should explain better:</p>
  
  <ol>
  <li><p>1000 to be presented as 1,000g</p></li>
  <li><p>0.75 to be presented as 0.75g</p></li>
  <li><p>0.2 to be presented as 0.2g</p></li>
  <li><p>0.1234 to be presented as 0.12g</p></li>
  </ol>
  
  <p>I've tried using a custom number format of <strong>#,##0.##g</strong> but this does not satisfy my first requirement (a) where the numbers are whole numbers and leaves an insignificant decimal point (i.e. 1,000.g), although does very well at formatting the remaining three requirements (b, c and d).</p>
  
  <p>Is there a way of overcoming this?</p>