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 doesnt 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.
Solved by S. L. in 24 mins