xsl-list
[Top] [All Lists]

RE: XSL/XML to Excel

2003-01-22 10:15:00
[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(_at_)onebox(_dot_)com - email


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



<Prev in Thread] Current Thread [Next in Thread>