HiI am using Asp.Net 2.0 and C# 2005. I have created a web page and i am exporting that page in excel,but the problem is that when the page gets displayed in ms excel the format is getting changed.That is receipt number is a column in grid and 234500009890 is a row in that column ( here 234500009890 is the receipt number ) then in the excel page it is showing as 2.34E2 something like this.This is just an example of the error that i am facing.I want the receipt number in the same format as it is.I dont want the format to change.Please help and provide with ur valuable suggestions.Thanks and RegardsPraveen Kumar

Hi there,

You can either change the formatting of the cell to simple Text in Excel, or you can prefix the exported value with a tick (') so Excel treats it as a simple string, rather than as a large number.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!