Hi All,
I am trying to create a custom number format that applies “M” for millions and “K” for thousands, and that also varies the number of decimal places as the numbers get bigger. This is where I am at at the moment…
[>=1000000]#.00,"M";[>=100000]#,"K";[>=1000]#.0,"K”;
…but this format doesn’t seem to process. Here are some example numbers of the format I am going for…
(zero to be invisible)
3
36
365
3.65K
36.5K
365K
3.65M
36.5M
Any help with this issue would be greatly appreciated.
