Oct 07 2022 09:57 PM
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?
Oct 07 2022 11:14 PM
@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"