Excel format changes from Number to Text

ajindal · February 5th, 2005, 03:38 AM

Hi All,

I am inserting Data from Access into Excel sheet with asp.net.

The problem I am facing when I try to insert field like Pin number or any numeric data It is inserted in the excel sheet as Text always (which is error in excel sheets).If I try to retrieve values back from excel the values are not retrieved back.

Can any one suggest me how can I change the format while inserting in excel sheet or How I can capture values.

Thanks in advance

Regards
Amit

ajindal · February 7th, 2005, 02:41 AM

Well I solved the problem. I find the reason for problem was change of format from number to text, so I make deafult format to text even for numbers. So the problem of non capturing of data in case one data is "number" and other is "number as text" is solved, as both are in text format now, so no error.

gautham82 · July 24th, 2007, 06:56 AM

Quote:

quote:Originally posted by ajindal
Well I solved the problem. I find the reason for problem was change of format from number to text, so I make deafult format to text even for numbers. So the problem of non capturing of data in case one data is "number" and other is "number as text" is solved, as both are in text format now, so no error.

Hi, need your help regarding entering value in excel 1-2, kindly send me ur mail id to [email protected]