RE: [xsl] XSL/XML to Excel

[cknell@xxxxxxxxxx]

[Lee, Insoo]
> Only thing is for excel, I noticed that it drops all 
> leading zeroes by default so that 
>
>  <myTag>0000123</myTag> would show up 123 in excel cell 
> instead of 0000123
>
>  Any trick I can use in XSL to show it correctly in excel?
>  Thanks

I think you'll find that Excel is dropping your leading zeros because it interprets 0000123 as 1.23 * 10^2 instead of as the string '0000123'. If you place a leading single quote before the first zero (<myTag>'0000123</myTag>), Excel will interpret it as a string.
-- 
Charles Knell
cknell@xxxxxxxxxx - email


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list