Custom format : Negative for K and M

[henrytran]

I want to custom format for number fields as follows:

1,234,567= 1.23M
-1,234,567= -1.23M
123,456= 123.46K
-123,456= -123.46K

But I use format [>999999]#.00,,"M";[>999]#.00,"K";#,##0.00; I have the problem
-1,234,567= -1,234,567
-123,456= -123,456

Please advise me if I can set format positive and negative for both M and K.

Thank you.

 

[henrytran]

I'd like to thank Rick Rothstein and DrSteele, because I follow those threads and it works.

 

[DRSteele]

You're welcome. I'm glad it worked for you. Thanks for the support!