Data format

Hello,

I am trying to replace any number that reaches 1000 by 1k, and 1 000 000 by 1M and so on. For example, If I have 1500. I would like it to be 1.5k . If I have 1500 000 I would like it to be 1.5M
I have been trying many ways around the data format. Is there any suggestion you can give for it.

Thank you