If I happen to have £120,000,987 in a cell how do I store
that in a variable with all its formatting.

If I declare a variable as long or currency and store the
cells contents then it seems to store 120000987.

I wish to print out the number in a string and can't seem
to get the commas and £ sign to feed through.

Any help is much appreciated as ever.

Nick Shinkins