Hello,

I'm trying to export a report from an .asp page using th
Response.ContentType method. The only problem with the export is tha
when numbers are exported, if there is a 0 or more than one 0 in th
front of the number, it gets removed by excel when the export i
complete. Also, if the number is too long it gets auto-formated t
Scientific. I need to know if there is a formula that I can use on m
export to force the Number Cells to be Text only Cells so that I don'
loose the 0's in front of the number and also to prevent it fro
auto-formating to Scientific if the number is too long. Anyone kno
how I could do this

--
Message posted from http://www.ExcelForum.com