Hi everybody

I'm using excel 2010 to display data from a xml file, i'm having no problem importing the xml data source in a simple chart, but i have one issue : i want a specific row to use a date format in order to be able to sort it well. The cells format of the column have been set to date, but when i import/refresh the xml, the cells just appears as text, unless i double click on each of them, then the date format is applied...

Any way to make this works automaticly ?

Thanks for your help