Accounting zero using custom format option

hmmmm dont know why your doing negative 1 mill and why it would work

anyways here's my attempt

[>=1000000]($#.0,,"M");[>=1000]($#.0,"K");(-)

anything under 1000 will always so -
ie 3 shows as (-)
anything negative will also show as -(-)
on more research, you can only have 3 conditions.

to get around this

[>=1000000]($#.0,,"M");[>0]($#.0,"K");[Red](-)

zero & negative is now red (-)
0-1000 = 0.0K