Excel converts charaters to integers

[codefox]

I'm generating an excel by setting the contenttype of the response in asp. there is a column of numbers with preceeding zeroes. But when the excel sheet is shown in the browser, the preceeding zeroes are suppressed. I tried prefixing the field with apostrophe, but still excel converts them to numbers. how could i retain the preceeding zeroes in the column?

Thank you.

[Bullschmidt]

Try double quotes around the numbers.

[codefox]

Double quotes around the numbers still does not solve the problem of retaining the preceeding zeroes in an Excel sheet generated by ASP code.

[glenngv]

The link below won't provide the solution for your problem (I don't know why:(), but it may help on other html extensions for excel
http://archive.baarns.com/DevOnly/Notes/TechEd/Intr9711.asp

[codefox]

Thanks. Prefixing the asp tag with   works for me, as in

<td>&amp;nbsp<%= oRS("number") %></td>

[glenngv]

I'm glad you made it worked. I will take note of that trick. :)