ASP to Excel Problem

[nmath]

I have an ASP script that is querying a DB then rendered the results in Excel. The problem is that one of the DB field values that is being returned is "<= 5". This value is not being printed in the excel sheet because I am guessing it is reading it as a formula?? Is there a way to make ALL cells in the worksheet formatted as text? I am using Response.ContentType = "application/vnd.ms-excel" to render the ASP page in excel. Any help would be greatly appreciated!! Thanks so much!!

Nina

 

[ggriffit]

You can add a single quote - ' - at the start of each cell and that should force Excel to treat it as text. You can also have a look at

http://www.greggriffiths.org/webdev/both/excel/

which covers this type of functionality.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005

http://www.greggriffiths.org/livelink/