The moose likes XML and Related Technologies and the fly likes Excel Treating String as Date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Excel Treating String as Date" Watch "Excel Treating String as Date" New topic

Excel Treating String as Date

Harsh Mahey

Joined: Nov 07, 2002
Posts: 5
I have an XML which has a Data like <data>12-24</data> .When i bring this data in Excel using XSL and JSP ,the Excel shows it as 24 Dec.
I am using the following in xsl
<td style='color:black; font-family:Arial; font-size:8pt;' height="17">
<xsl:value-of select="."/>
I tried <data>'12-24</data> but then in Excel it comes like '12-24 and when i select the cell and press enter it gets converted to 12-24.
Any suggessions?
I agree. Here's the link:
subject: Excel Treating String as Date
jQuery in Action, 3rd edition