ReportViewer Export to Excel Numbers Formatted as Text
-
Hi, I have a local report running in asp.net 2 reportviewer. When I use the export to excel functionality of the reportviewer control, the numbers are exported as text in excel and I can not apply excel functions on the number fields. Do you know if there is a certain format I can use for excel to know its a number field. I used =FormatNumber(Fields!Balance.Value) AND =Format(Fields!Balance.Value,"### ### ##0.00") AND =Format(Fields!Balance.Value,"###,###,##0.00") none working. I removed the format all together and it still didn't make a difference. Please assist
-
Hi, I have a local report running in asp.net 2 reportviewer. When I use the export to excel functionality of the reportviewer control, the numbers are exported as text in excel and I can not apply excel functions on the number fields. Do you know if there is a certain format I can use for excel to know its a number field. I used =FormatNumber(Fields!Balance.Value) AND =Format(Fields!Balance.Value,"### ### ##0.00") AND =Format(Fields!Balance.Value,"###,###,##0.00") none working. I removed the format all together and it still didn't make a difference. Please assist
Did you use CDec(Fields!Balance.Value)