[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