Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formating Dates | Excel Discussion (Misc queries) | |||
Formating Dates | Excel Discussion (Misc queries) | |||
Dates Formating | New Users to Excel | |||
Formating dates | New Users to Excel | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |