As of right now I created a custom format for my 1000 to show up as 1k and my 1,000,000 to show up as 1.0m
Now the issue: How do I create a template to where my 0 shows up as (-) instead of (k)
Here is the formula
[<=-1000000]"-"$*(#.0,,"M");[<=0]$* (#,"K");(#,##0.0)
All help is greatly appreciated!
Semper Fi
Bookmarks