When exporting an xml file from excel, dates are become 5 digit numbers

jacka

New Member
When exporting an xml file from excel, dates are become 5 digit numbers.07/01/2010 becomes 40185.Same thing happens when I change the format of the cell from date to general.Any ways to match the 5 digit number to the date?Or someway to keep the date field in the xml file?
 
Back
Top