Format Cells for large numbers

[RodneyC]

I have a column with numbers from the low 100's to several million. When placing this data on a chart, it will be much easier to read if the numbers are 316K or 2.1M instead of 316,457 or 2,098,220. I know I can use 0, "K" to change the 316,457 to 316K and I've tried 0,"M" on the 2098 but it reads as 2098M as opposed to 2.1M.

I need a formula I can put in each cell that would convert to either the K or M rounded up/down number to display.

Thanks in advance

 

[Fluff]

You can use a cell custom format & use

[<1000]0.0;[<1000000]0.0, "K";0.0,,"M"

 

[RodneyC]

You can use a cell custom format & use

[<1000]0.0;[<1000000]0.0, "K";0.0,,"M"

and just like that, it works! Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.