Rounding Millions to Thousands

[Anonymous]

Hi guys,

I'm making a report and the amount of space on the sheet is becoming an issue. What I need to do is round a number like 13,346,890 to 13,347 and say that it's in 000's.

Anyone know how I can do that?

[dan_sullivan]

=(Measure / 1000)&'k'

[sunny_talwar]

May be this

=Round(13346890/1000)

[antoniotiman]

Num(Value/1000,'#,##0 K')

[Anonymous]

Ok. I used a combination of two answers-

=Round((Sum([[Sheet1-1.CY 2017])/1000))&'k'

The problem now is that there is no comma separating the thousands. It appears as such- 18439k

I want it to look like 18,439k

[antoniotiman]

=Num(18439623/1000,'#,##0 K')

[sunny_talwar · Accepted solution]

Try this

=Num(Round((Sum([[Sheet1-1.CY 2017])/1000)), '#,### k')

[sunny_talwar]

Or this (decimal after the last # in the format

=Num(Round((Sum([[Sheet1-1.CY 2017])/1000)), '#,###. k')