Custom formatting numbers

[tofayelahmed]

I wanted to abbreviate large numbers like 1000000 into 1M using the custom [>999999]#,, "M";#, "K" formula which should convert 1000000 into 1M or 100000 into 100K but instead, it shows 1000000,, M

Please can someone help?

[#2]

@tofayelahmed  wrote:  ``[>999999]#,, "M";#, "K"``

Works for me.  But for me, comma is the thousands separator.

My guess:  for you, period is the thousands separator.

So you should use Custom [>999999]#.. "M";#. "K"

[#3]

thank you. I just solved it.