velohead
07-13-2010, 05:56 PM
Hi All,
I have a variable (variable_1) that has the value 2000000
This has come from an excel cell, containing the value 2000000
Now, I want to use the variable as a string, but in the format of $2,000,000
How would I convert the variable value to $2,000,000
Or would I need variable_2 based on variable_1
Not sure how to procede on this, would anyone offer a way forward.
I have a variable (variable_1) that has the value 2000000
This has come from an excel cell, containing the value 2000000
Now, I want to use the variable as a string, but in the format of $2,000,000
How would I convert the variable value to $2,000,000
Or would I need variable_2 based on variable_1
Not sure how to procede on this, would anyone offer a way forward.