help with formats please
 

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

help with formats please
 

£##.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

help with formats please............. Thanks
 

Thanks for the help. The £8.5K was my mistake, I meant 8.9.

K


"Gord Dibben" wrote in message
...
£##.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