Format cell does not work for Negative Value

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"

Conditional formatting is needed.

New rule > use a formula =A1<0

then custom number format
[<-999999999] -#,###.00,,, "B";[<-999999]-#.00,, "M";#.00, "K"

Hi Bo_Ry,

Thanks a lot. solve my problem