xsl stylesheet formatting

[Charlie]

For some reason when I export to excel using a xsl file, the numbers are not
coming out correctly. Here is the code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:xdt="http://www.w3.org/2004/10/xpath-datatypes"
xmlns:fn="http://www.w3.org/2005/02/xpath-functions">
<xslutput method="text"/>
<xsl:template match="/">Cusip
<xsl:for-each select="REPORT/POS/POS_ROW">
<xsl:text>
</xsl:text>
<xsl:value-of select="normalize-space(CUSIP)"/>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>


The Cusip should be 00000129 but it is coming out 129. All of the zeros
are getting surpressed. Any idea why? Thanks in advance for your help.

 

[Ian]

I don't understand xsl files so I don't know how to correct yor problem, but
the reason the zeros are being suppressed is because that is whay Excel does
with leading zeros. I you can enter the data as text instead of a number,
that will cure the problem. To illustrate this, format a cell as Text and
type a number in it. The leading zeros will be retained.