Formatting Text and Dates in Excel Output

[mdr2271]

I am writing some output to Excel on an ASP page and was wondering how to format the field in Excel to be text vs numeric. Our ID numbers are of the format 0000123 and are a text field. When the field is exported to Excel it shows up as 123 and not 0000123 like we need it.

Also, how can you format a date field to export to Excel?

 

[ggriffit]

take a look at

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

which covers some of this.


Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005

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