title: Format 1234 as 1.2K in Excel
body: <p>I would like to format numbers in Excel to use a K to represent thousands but I would like to have numbers displayed to the nearest hundred not just the nearest thousand. I would also like to include a $ sign and () for negative numbers. Is this possible using a custom number format?</p>
  
  <p><a href="https://i.stack.imgur.com/ntBsu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ntBsu.png" alt="enter image description here"></a></p>