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 |
All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com