Connecting Tech Pros Worldwide Help | Site Map

Export to Excel issue...

karthick
Guest
 
Posts: n/a
#1: Feb 18 '07
Hi,

I am exporting a Gridview to Excel and it works fine without any
issues.

But as one of the field holds values such as "71646E100" it gets
converted to: "7.16E+104" (like a formula) in Excel. How can I prevent
this from happening ?. I need to value to be in Excel as it is
displayed in the Gridview (on the web page).

Any help is much appreciated. Thanks.

Karthick

Ignacio Machin \( .NET/ C# MVP \)
Guest
 
Posts: n/a
#2: Feb 19 '07

re: Export to Excel issue...


Hi,

"karthick" <karthick.thoppe@gmail.comwrote in message
news:1171822947.274285.152720@k78g2000cwa.googlegr oups.com...
Quote:
Hi,
>
I am exporting a Gridview to Excel and it works fine without any
issues.
>
But as one of the field holds values such as "71646E100" it gets
converted to: "7.16E+104" (like a formula) in Excel. How can I prevent
this from happening ?. I need to value to be in Excel as it is
displayed in the Gridview (on the web page).
Jst a dumb question, did you try to increase the width of the excel column?


Closed Thread


Similar C# / C Sharp bytes