Thread: Hiding Decimals

Hello,

I am trying to produce a number format that will do the following...

4700 = 4.7K
4000 = 4K
4700000 = 4.7M
4000000 = 4M
470 = 470

I'm using the following formula which ALMOST works...

[>=1000000]0.#,,"M";[>=1000]0.#,"K";0.#

The only problem is that in the case where a K or M is shown and there is a zero decimal place, then it shows the decimal. I want it hidden.

ex. 4000 shows as 4.K instead of 4K

Any ideas on how to hide the decimal in this condition?

Thanks,

Ian