Excel: Custom format : Negative for K and M

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.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of February 28, 2017.

For more resources for Microsoft Excel