One way, assuming only positive numbers:

Format/Cells/Number/Custom

[<1000]General;[<999500]##0,K;#,##0,,\M

In article ,
Need Help! <Need wrote:

I was wondering if it is possible to get excel to automatically convert
numbers from lets say 10 000 to 10k, or 10 000 000 to 10M etc.