How to keep display format when exporting XML from excel?

D

david

When exporting xml data from excel 2003, the time values lose their
readable format. The value that was displayed as 01:30 am, for
example; becomes something like 0.001353 in the xml file.

What do I need to do to allow the exported xml file to keep the same
format as what is displayed in Excel?
thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to keep display format when exporting XML? 0
Have excel export cell format other than text; need time and date not number value 0
Microsoft Project - error opening exported XML file 0
Images are pixelated when saving to PDF 0
Connection/Refresh Control unavailable for imported XML data 0
Exporting from Excel 2007 (xlsx format) to XML 0
VBA - exporting serial letters to single documents 0
Help Creating XML File from Spreadsheet 1

Top