Add comma to the given number

[satishkumarm]

how to add comma to the given number

for example if number is 2000 then it should display 2,000

and if number is 20500 then it should display 20,500

I request some1 to give me the function for displaying the format mentioned as above...

[Palanimurugana]

Could you try with below codes.

Code:

str=FormatCurrency(2000)
str=Mid(str,2,len(str))

[satishkumarm]

Thank you very much

[Anand]

Go to the following Link

http://www.devguru.com/technologies/vbsc...umber.html