help with formats please

D

dido22

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
 
G

Gord Dibben

£##.0,K

Note: this will give £8.9K not 8.5

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



Gord
 
Top