Custom format number to thousands

[FryGirl]

How do I custom format a number into thousands.

Data Range

	P​	Q​
9​	25068​	25 k​
10​	25568​	25.5 k​

<tbody>
</tbody>

Using 0.0" k" I just get


Data Range

	P​	Q​
9​	25068​	25068.0 k​
10​	25568​	25568.0 k​

<tbody>
</tbody>

 

[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