Force an Excel cell to be a text label type regardless of data.

This is helpful when exporting on the web to Excel and numbers have leading zeros or extremely long numerical values and truncation is not desired.
HTML


"<td style='vnd.ms-excel.numberformat:@'>" & sdoc.EmployeeID(0) & "</td>"

"<td style='vnd.ms-excel.numberformat:@'>" & sdoc.InvoiceNumber(0) & "</td>"


Posted by fbrefere001 on Tuesday January 3, 2006