Problem when downloading
 

Hi,

I am downloading a .Net programs output to Excel (which contains n number of
records). In that output, a Column contains 30 digits, whenever I am trying
to download, excel is converting and displaying it to exponential form, but I
want to display the entire digit as is. I tried by changing the cell format
to Text, but no use. And I concatenated with a single quote (') in front of
the column, and then downloaded, but it is displaying the whole number with
single quote. But I want to display only that 30-digit number.

Note: .Net program is extracting data from database using SQL, in which it
declared as numeric.

Please help.

Thanks in Advance,
Soundar.