Number convert or formatted as "K" thousand

[comebackevents]

Hey guys,

I was wondering if anybody have a solution to do this :

Number in the database : 1000
Show it as : 1K

And so on (1K for between 1000 and 1999, 2K between 2000 and 2999, etc)

Thank you,

[jonathan.baxter1991]

One way to do it would be to divide the number by 1000 and then format it with either 0 or 1 deciemal place. Although with 0 decimal places 1500 would round up and show 2K. With 1 decimal place it shows 1.5K.