Subject: RE: XSL/XML to Excel
From: cknell@xxxxxxxxxx
Date: Wed, 22 Jan 2003 12:15:00 -0500
|
[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
|