[thelist] excel output -- long number problems

Paul Cowan evolt at funkwit.com
Thu Aug 4 18:30:53 CDT 2005


On 4/08/2005 11:34 AM -0400 Brian Cummiskey wrote:
> for x = 0 to rs.Fields.count - 1
> 	Response.Write "<td>'" & trim(rs.Fields(x).Value) & "</td>" & vbcrlf

try

Response.Write "<td>=""" & trim(rs.Fields(x).Value) & """</td>" & vbcrlf

="0001" in excel will make the cell display as text (e.g. won't use 
scientific notation, will leave leading zeroes, etc). Note that this then 
means you can't SUM the column, etc., but if you're happy for it to be 
treated as text we're all good!

Cheers,

Paul


More information about the thelist mailing list