Date formatting of xml in Excel 2003

J

Jeremy Holt

(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top