[thelist] excel output -- long number problems

Brian Cummiskey Brian at hondaswap.com
Thu Aug 4 10:34:38 CDT 2005


I have an asp worksheet, which has a "save to excel" button on it.
This save to excel page is just the same asp code as the results page, 
only with the added header to make it pop open in IE as excel.  (IE 
only, this is internal)

All is well, except our unique ID's that i'm pulled are 15 digits long 
for some records, and i'm getting the 15E-23412 number format.

I tried changing:

for x = 0 to rs.Fields.count - 1
	Response.Write "<td>" & trim(rs.Fields(x).Value) & "</td>" & vbcrlf


to:

for x = 0 to rs.Fields.count - 1
	Response.Write "<td>'" & trim(rs.Fields(x).Value) & "</td>" & vbcrlf


Note the ' after the TD.  Normally in excel, the tick will make the cell 
format as text.

Well, it does...  but its printing the tick out as well.

anyone deal with this before?


Thanks






More information about the thelist mailing list