Custom Cell Style Format [>=1000000]#,," B";[>=1000]#," M";0" K"

Can anyone help me with the above custom cell format?

The value I'm evaluating has already been divided by 1000, so...

If the the number is > 1,000,000 (#,000,000 x 1000) then the number will be appended with an "B" to the end.
If the the number is > 1,000 (#,000 x 1000) then the number will be appended with an "M" to the end.
If the the number is > 1 (# x 1000) then the number will be appended with an "K" to the end.

Everything works great but I don't want the value to be rounded up if its less than 1.

I've tried adding:

Please Login or Register  to view this content.

but the editor really didn't like that!


Any help would be greatly appreciated.

Thanks.

Did you try:
0.0 " K"?