Tuesday, September 25, 2001 03:13 PM
I have a servlet that outputs an MS Excel file. It works great except for one thing. One column has SSNs. SSNs, of course, look numeric but can have leading zeroes. When the Excel result page appears, it cuts off those leading zeroes.
If I were manually creating the spreadsheet, I'd change the properties to that column to text before importing that data. Is there any way that I can force that to happen in my servlet? Or is there any other way that I can make the leading zeroes stay?