Number Format

[Damien]

Is it possible to have a number format for thousands of
pounds?

eg format
'10,000' as '10K'
'100,000' as '100K'
etc

I know this could be done with a formula, but am wondering
if it can be done with a custom number format.

Thanks


Damien

 

[Eamon]

One way...

Format, Cell, Custom and enter #,K

Eamon

 

[Frank Kabel]

Hi
try the ustom format
0, "K"