Currency formatting
 

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

Currency formatting
 

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

"Nick" schrieb im Newsbeitrag
...
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

Currency formatting
 

Thanks for your solution

It works a treat.

Nick



-----Original Message-----
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

"Nick" schrieb im
Newsbeitrag
...
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

.