Exporting To Excel With ASP - Number Problem

  • Thread starter Thread starter williamsd
  • Start date Start date
W

williamsd

Hello,

I'm trying to export a report from an .asp page using th
Response.ContentType method. The only problem with the export is tha
when numbers are exported, if there is a 0 or more than one 0 in th
front of the number, it gets removed by excel when the export i
complete. Also, if the number is too long it gets auto-formated t
Scientific. I need to know if there is a formula that I can use on m
export to force the Number Cells to be Text only Cells so that I don'
loose the 0's in front of the number and also to prevent it fro
auto-formating to Scientific if the number is too long. Anyone know ho
I could do thi
 
William,

Rename your file to a .txt and then when you open it using Excel, use the
wizard to format those columns as text.

HTH,
Bernie
MS Excel MVP
 
I'm not using the FileSystemObject Method I'm using th
Response.ContentType method, it opens an ActiveX type control in th
browser
 
Back
Top