Formatting a number as thousands

[#1]

Really simple one here!

How do I write an expresion that formats numbers as £10k (for example).

I know I need to concatenate the 'k' on the end, but can't seem to find the right script to do this.

Cheers

Tom

[ecolomer]

You can use that:

=Num([your_field]/1000,'#,##0.00 k')

your field divided by 1000 and whit the format