'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:
- 499,998 results in
$499K - 500,000 results in
$0.5M - 1,000,000,000 results in
$1,000M - -500,000 results in
-($0.5M) - -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 |
|---|
