excel xml

J

joost

Hello

To creacte a webpage with lot a data i want to export this data from excel
to xml. So far so good
While exporting the data the date format changes in the excel number and not
the dd-mm-yyyy format.

Numiek value for example 10,05 is change in 10,0494449 (the original value)
but i only want two digi 10,05.

Can anybody help me

thanks in advance
 
D

David Biddulph

You may need to produce a helper column, either using the ROUND() function,
or the TEXT() function.
 

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

Import to Formatted Worksheet 1
Date format getting muddled 3
Date Format changing when exporting from another app 1
counting records by month and year / date format issues 1
Excel 2002: How to make the date format uniform ? 1
Date format changes in mail merge using Excel worksheet as data 2
Convert dates stored as text 2
Delete Timestamp 2

Top