I am using SSRS and one of the column in my report is having both Text values and Numeric values.
e.g.
A
U
1
2
Y




While doing export to excel, for numeric values there is a TAG coming in the cell (excel file) with message "The number in this cell is formatted as text or preceded by an apostrophe."
How can I remove the TAG and the message for numeric values.