c# - Data format issue. Export GridView to Excel -
there string (1008901023816550000000) in gridview somehow saved scientific number (1.0089e+21) in excel when exported gridview excel. i using .net 4.0. here tried, didn't solve problem: added dataformatstring="{0:g}" boundcolumn tag. set style after rendercontrol called. string style = @" .text { mso-number-format:\@; } "; can shed light on problem? presuming using csv file perform export: this quirk of excel that's hard shake. idea know of try using format inside csv file: ="1008901023816550000000" this force formula returns desired text.