Prefix number with '

[JohnD0e]

I posted a question a few weeks ago and a solution was found and some great code was written by JBeaucaire and others. I now just need to enhance the maco a little and have the result prefixed with a '

Please Login or Register  to view this content.

The macro works just fine and rounds a number to 2 decimal places but I need the resulting numberto be prefixed with a '

Eg at the moment

100.5346666 would become 100.53 and what i want to do is have it '100.53


I had tried the following

Please Login or Register  to view this content.

But with out any luck

So Any help on this issue would be great ;-)

[shg]

Please Login or Register  to view this content.

[DonkeyOte]

And for the sake of demo'ing the Eval method:

Please Login or Register  to view this content.

if you want the apostrophe as opposed to just storing as text - remove the NumberFormat line and use ""'""&ROUND(...)