Hi there,
I'm developing a telerik report in which I just want to display a set of coloumn value in Indian currency format after excel download. I have done this with the help of calling a currency converter function.
Output came like this,
5,25,600.00
5,25,600.00
10,75,600.00
10,00,00,000.00
1000.00
1000.00
10600.00
10600.00
23.00
3333.00
Now I just want to make sum of this column, but it downloaded as text format not in number format, though I changed it to number format in format cell option, values like 5,25,600.00 ,10,75,600.00, 10,00,00,000.00 which are all having "," in between the numbers cannot be added. How to change these values into number format. Suggestions welcomed.
Thanks in advance.
Regards,
A.Sundar.