adding K or M to number

[lezawang]

Hi
I want to add K or M to numbers, for example 1000 i want it this way 1K and 1000000 i want it 1M.
So for 1K I did this custom formatting

#; \K

It did work find in the number is 1000 and above but if the number is less than 1000 then excel will put K. Is it possible to remove K when the number is less than 1000?

 

[AhoyNC]

Maybe something like this in custom formatting.

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

 

[Rick Rothstein]

Maybe something like this in custom formatting.

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

There should be two commas after the 0 for the "M" format, not just one as you posted above...

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

 

[lezawang]

Thank you all for the help. Now I understand the code but I now have a question about these 3 parts. I know this synatax

positive ; negative ; zero ; text

why excel use your code for +ve numbers only, i thought your second part [>=1000]#.0,"k"
should be used for -ve numbers?