I would like to ask your advice about a problem I'm experiencing with dates.
To cut a long story short I have an xml file like this:
<CELL format="mm/dd/yyyy">5/6/2007 12:00AM</CELL>
this excel is used to generate an Excel file, using the format attribute for the cell Style.Custom property. Everything works fine except for the second cell of the first row: the text is not formatted.
If I delete the "12:00AM" everything works fine also for this line.
I would like also to report the fact that if the format is set to "mm/dd/yyyy hh:mmAM/PM" the AM and PM is displayed as Am or Pm where m is the number of the month.
Thanks a lot.