Formatting - chose different type of number format/round based on value

[wintermute]

Hi all,


is there a way to format number type based on value?

My target is to format number like


7856 as 7K

3 234 567 as 3M

234 as 234


all that with just one format setting?


I've tried

[>10000]0 "K";[>1000000]0 "M";[<1000]0 ' using central Europe regional settings but it won't work as requested.

 

[Luke M]

Need to have the largest value listed first, work down from there:

[>=1000000]0,,"M";[>=1000]0,"K";0