The currency or amount is converting into string.

[amaranadh-wal]

We are mapping a our numbers to a column in the currency format like $10,000.36. It is converting as string. When we open the file with google spreadsheet or any other xl tool it is not showing total sum of the selected cells in the column.