When I export to XML from Excel 2007, how to I maintain the date format?

K

KeCe

New member
Joined
Jul 9, 2008
Messages
21
Reaction score
0
Points
1
(mm/dd/yyyy)? I've successfully exported a Excel 2007 file to a XML file using Excels built in XML exporter. My problem is that the dates and percentages change when exported to the XML file. The dates are converted to serial dates and the percentages are converted to decimals from 0.0-1.0

My question is, how do I export this information as I see it in excel? For example, I'd like to export mm/dd/yyyy and ##% to the XML file. Any ideas?

Thanks!
 
Back
Top