How to reduce decimal places on format pattern

[#1]

I have a value of £1,000,000,000,000 I want this down to £1,000B or similar.

Any help would be good.

[JonnyPoole · Accepted solution]

You would need to divide the value by 1000000000  (one billion) and then use a format mask with a B on the end.