Thousand and million formatting for negative numbers excel googlesheets

Question

Hello I currently use this formatting to show big numbers as either 1.2M or 20K (instead of 1 200 000 ans 20 000):

[>999999]0.00,,\M;[>999]0.0,\K;0.0,\K

I have an issue with negative numbers, I can show -20K but how can I also show -20M?

Answer 1

Its not possible. What you could do is add a formula like this or you could use conditional formatting along with multiple formats like this.