Currency formatting

N

Nick

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
 
F

Frank Kabel

Hi
try
vstr=format(var,"$0,0.00")
or something similar.
Note: This way you store it as a string!

--
Regards
Frank Kabel
Frankfurt, Germany

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
 
Top