[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: XSL/XML to Excel
[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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|