I have a great range of values to report. I am trying to create a custom number format to look as below: I do not know vba, so any formula help would be so appreciated.
This is the result I’m trying for:
$1,600,000 = $1.6MM
$13,500 = $13.5K
-$1,600,000 = ($1.6MM) - to be shown in red...