Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use that:
=Num([your_field]/1000,'#,##0.00 k')
your field divided by 1000 and whit the format