Custom format number to thousands

[FryGirl]

How do I custom format a number into thousands.

Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

P​

[/TD]
[TD]

Q​

[/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

25068​

[/TD]
[TD]

25 k​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

25568​

[/TD]
[TD]

25.5 k​

[/TD]
[/TR]
</tbody>[/TABLE]

Using 0.0" k" I just get


Data Range
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

P​

[/TD]
[TD]

Q​

[/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]

25068​

[/TD]
[TD]

25068.0 k​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]

25568​

[/TD]
[TD]

25568.0 k​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[RobertSF]

Use a custom format.

25068 with custom format 0.0, k looks like 25.1 k
25568 with custom format 0.0, k looks like 25.6 k

25068 with custom format 0, k looks like 25 k
25568 with custom format 0, k looks like 26 k

However, you can't make 25068 look like 25 k and 25568 look like 25.5 k with the same custom format.

Hope that helps!

 

[Dryver14]

custom format 00000 k returns the full number then k but 1500 would change to 01500 k

 

[FryGirl]

Thank you, got it. It was the comma I was missing.

 

[mole999]

dont forget you can also use # as in ####0 k to loose leading zeros

 

[Dryver14]

Cheers Mole999 - That's a learn for me

 

[FryGirl]

Yes, thanks Mole999