Hi,Asheesh ..! Just put the character ' before the 000123 and then enter into the cell.you will see your prob. will be solved.
(i.e. insert '000123) Cheers-) Nimesh. --- In [email protected], "Asheesh S Parihar" <[EMAIL PROTECTED]> wrote: > > In order to create an Excel report dynamically, I am simply using below > piece of code > > > > Response.AddHeader("Content-Disposition","attachment;filename = " + > strOutPutFileName + ".xls"); > > Response.ContentType= "application/ms-excel"; > > Response.ContentEncoding=Encoding.UTF7; > > > Here I am facing formatting problem. I'm populating a cell with a character > string, but if that string (i.e. 000123) is to be numeric, then it displays > 123. Result should be 000123. How can I solve this problem? > > Thanks and Regards, > Asheesh > > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
