£##.0,K

Note: this will give £8.9K not 8.5

Use Alt + 0163(numpad) to enter the £ sign



Gord




On Fri, 2 Mar 2012 12:41:47 -0000, "dido22"
wrote:

Hello,

I have numbers in currency format, eg £8900.00 which I want to display as
£8.5K . Can someone help me with the format for this please ?

Thanks

KK