Hi All,

I have set a format cell for large numbers. However, when the numbers is in negative value, it does not work due to actual value is <0.

Can anyone help to modify this formula?


[>999999999] #,###.00,,, "B";[>999999]#.00,, "M";#.00, "K"