6000 -> 6K. Possible with number formats?

[Frederick Chow]

Hi all,

Is it possible to set a number format code in cell in such a way that, when
say, 6,500 is typed, then 6.5K will be shown? Thanks for your advice in
advance.

Frederick Chow
Hong Kong

 

[Bob Phillips]

Format the cell as

#,##0.0,K

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Ken Wright]

Just to add to Bobs post - every comma you add at the end suppresses 3
decimal places, so 2 commas will give you millions and so on.

 

[Ken Wright]

BUT - Be aware that this FORMATTING only, and does NOT change the actual
number, so even though it looks like 6.5, it in fact 6,500.