View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart Shay Stuart Shay is offline
external usenet poster
 
Posts: 1
Default Excel XML - Formating Dates

Hello All:

I have created a ASP.NET Web Application that takes the contents of DataSet
XML and Transforms the XML into Excel XML.

Ver: Excel XP
In the XML the dates are in the following format

<DateStamp2004-08-04T17:56:09.4330000-04:00</DateStamp
<DateStamp2004-08-05T15:59:17.6700000-04:00</DateStamp
<DateStamp2004-08-05T15:58:30.0770000-04:00</DateStamp

In my XSLT I have something like this
<Cell ss:StyleID="s30"<Data ss:Type="String"<xsl:value-of
select="DateStamp"/</Data</Cell

If I define the Datatype as a DateTime a error occurs, I would like to
format the date such as
Aug 8, 2004 12:23 AM

Is there a way I can format the date col to my worksheet so it is more human
readable.

Thanks
Stuart