i have generated an report viewer and when i select excel it downloads the rdlc perfectly and i have a column amount and year in the excel which gives a error it says the number in the cell is formated as text or precede by a apostrophy.
when i click on that acount number column it changes the value like 65AE +34df something like this which is a column cell of the excel.
how to overcome this.