Exporting To Excel With ASP - Number Problem

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
 
B

Bernie Deitrick

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
 
W

williamsd

I'm not using the FileSystemObject Method I'm using th
Response.ContentType method, it opens an ActiveX type control in th
browser
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Problem With Exporting To Excel Using ASP 0
Exporting To Excel With ASP - Number Problem 8
16 digit numbers 11
Numbered list problem 6
Conditional formatting disappears when cell contents deleted 2
Truncating Number Series 3
Macros to convert Data into date format and then plot in graph 7

Top