How do I change big number with letters?

Hi all,

As title I would like to know if is possible change a big number in letters

1000 1k

1000000 1M and so on

I tried as image and is working a bit the only problem that I found is that the number after the coma are 3 for the k and 6 for the M

How can I round that number just in 2 number after the coma

I think they want the number rounded to 2 decimal places...

round(COIN / 1000 * 100) / 100 & "K"

and

round(COIN / 1000000 * 100) / 100 & "M"

Thank you all but is still not working

If I'm using round function is show me just whole number not decimal.

I give an eg

I want the number 1345789 to be just 1.34M e not 1.345789M or 2M

The way AllanR wrote it, you would get what you want. You need to do this: round(COIN/1000000*100)/100&"M" and not this round(COIN/1000000)&"M"

Thank you all,solved