View Single Post
 
Old 02-01-2012, 10:52 PM
achuki achuki is offline Windows XP Office 2003
Novice
 
Join Date: Feb 2012
Posts: 1
achuki is on a distinguished road
Default Handle Text / Numeric values in SSRS while Export To Excel

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.
Reply With Quote