I'm trying to create a custom number format that will display big dollar amounts with the typical k/M suffixes. Examples:
- $1
- $12
- $123
- $1.2k
- $12.3k
- $123k
- $1.2M
- $12.3M
And, actually, I partially managed with the custom number format:
$[>999999]#.#,,\M;$[>999]#.#,\k;$0
My question is how to expand this custom number format to include negative numbers too:
- -$1
- -$12
- -$123
- -$1.2k
- -$12.3k
- -$123k
- -$1.2M
- -$12.3M
I would really like to avoid having to create an auxiliary row or column for this.