Hey Lee
The trick to get excel to show the leading zero is to use = (for example if
you were outputting to a table for excel...):
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=UTF-8">
<meta name=ProgId content=Excel.Sheet>
</head>
<table>
<tr>
<th>Name</th>
<th>Username</th>
<th>Address_1</th>
<th>Address_2</th>
<th>Address_3</th>
<th>Address_City</th>
<th>Address_Postcode</th>
</tr>
<tr>
<td>MR A</td>
<td>="012345"</td>
<td>Stan</td>
<td>Here St</td>
<td>This Place</td>
<td>Cristchurch</td>
<td>="00125"</td>
</tr>
<tr>
<td>Mrs B</td>
<td>="000882"</td>
<td>Fran</td>
<td>Here St</td>
<td>This Place </td>
<td>Aukland</td>
<td>="00126"</td>
</tr>
</table>
</html>
Hope this helps,
Ro.
From: "Lee, Insoo" <Insoo(_dot_)Lee(_at_)gs(_dot_)com>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
To: "'xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com'"
<xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Subject: [xsl] XSL/XML to Excel
Date: Wed, 22 Jan 2003 11:39:11 -0500
Not sure if this is the appropriate newsgroup, but any help would be
appreciated.
I'm using XSL to stylesheet XML and output it to html and excel and they
work great.
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 in stead of
0000123
Any trick I can use in XSL to show it correctly in excel?
Thanks
IL
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list