View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeremy Holt Jeremy Holt is offline
external usenet poster
 
Posts: 2
Default Date formatting of xml in Excel 2003

(This may be a double post - apologies)

I've just downloaded Excel 2003 and was messing around with the XML import
function. When importing an ado.net dataset (created with
ds.WriteXML(filename.xml,XmlWriteMode.WriteSchema) , Excel does not natively
format dates in the format 2003-08-24T00:00:00.0000000-03:00.

While I could write a parser, I would rather not have to create a new column
to do something which Excel should be able to recognize as a date.

Any thoughts on this?

Thanks
Jeremy