'How to Create a Short Sign for K and M with negative values inside parenthesis

So I created this custom number format

[>499999]"$"#,##0.0,,\M;[>-1]"$"#,##0.0,\K;* ("$"#,##0.0,,"M");(_@)

Sample Result:

  1. 499,998 results in $499K
  2. 500,000 results in $0.5M
  3. 1,000,000,000 results in $1,000M
  4. -500,000 results in -($0.5M)
  5. -499,998 results in -($0.5M)

Question

  • Is it possible for Sample #3 to become $1.0B
  • Is it possible for Sample #4 to become ($0.5M)
  • Is it possible for Sample #5 to become ($499K)


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source