Data exported as text for numeric column

[gopigupta]

Hello,

I need one help for export.

I am exporting grid into excel file. The data for grid is coming from server side(.net code) and it is coming in text format for all columns even for numeric columns. I have kept datatype as "float" and format as "##,###.00" for numeric columns in grid but still when I export data, numeric columns are exported as text in excel file.

Is there any easy way to change data into numeric before we export it into grid.

Thanks.   

[paramvir]

you need to correct the server side code to return numbers for numeric columns.

or

convert string values to numbers in dataModel.getData callback.

[gopigupta]

Thanks you for quick response