I can't manage to find a way how to format numbers like below:

Original Number: 65000
I want it formatted this way: 65,000

I tried various ways using the FormatNumber function but I can't get exactly what I want. I want to display a comma after the third number from the right. It must be a comma and not a point.

Can anyone please help me

Thanks You

Hi

Usually you would not want to store your numbers in the database in that format but only display. You could add the commas on client side using java script.

Check this link: http://javascript.internet.com/messages/add-commas.html

Hope this helps

Regards
Marnus