How do I convert an alphanumeric field in SSRS and export to excel to avoid the number stored as text error?
Posted on 2011-02-22
I have a report with 12 columns. 11 columns export fine to excel. However, I have one of the SSRS columns that is an numeric & alphanumeric, aaa1111....etc.. When I export to excel and I open the file to view I have the green error mark in the cells of that column that are just numbers.
If I change to the expression =CDbl(Fields!your_numerical_column.Value) on the field all of my numbers only are corrected but the alphanumeric have errors. Please assist.