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.
 
Top