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.
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.