Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003: Error with date formatting | Excel Discussion (Misc queries) | |||
Conditional formatting by day of the date in Excel 2003 | Excel Worksheet Functions | |||
excel 2003 formatting | Excel Discussion (Misc queries) | |||
In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) |