I'm trying to create a custom number format that will display big dollar amounts with the typical k/M suffixes. Examples:
And, actually, I partially managed with the custom number format:
My question is how to expand this custom number format to include negative numbers too:
I would really like to avoid having to create an auxiliary row or column for this.