Zip Code Is Dropping Leading Zero When Displayed On Excel. Export To Excel From XML To XSLT Transform?Aug 16, 2010
I am exporting data from vb.net to excel and it is dropping the leading zero when its displayed on excel. How can I avoid the dropping of leading zero? I read the solution of adding a single quote but it makes my excel sheet column ugly. Also users will complain if they see a single quote on zip code field.vb.net code
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
the stored procedure outputs XML and it is transformed by XSLT before it is displayed on EXCEL
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
adding a single quote or manipulating excel sheet with column formatter (general/numbers ) etc. I don't want user to make any changes on excel to get the display properly when the excel is displayed from web page it should be all set with proper formatting. also we have no control over client excel software?