export to excel column error generating from rdlc

Nov 12 2019 10:46 PM

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.