Custom formatting numbers

New Contributor

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 Replies

@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"

thank you. I just solved it.