Output Variable as a comma seperated Number

Is there any way to output a Variant as a comma seperated number without changing the format of the cell?

I'm basically trying to do something like :

Please Login or Register  to view this content.

where sum is a variant. currently, if the variant is 10235.10, it would display exactly like that, I want it to display as "10,235.10", any idea?

Thanks in advance!

Try this:

Please Login or Register  to view this content.

Originally Posted by Kuskush

Try this:

Please Login or Register  to view this content.

tried it, didn't work

Check the option settings (in Excel 2003: extras>options>international).
If the separator for 1000s is set to "," the suggested code should do what you asked for.