excel xml
 

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

excel xml
 

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

"joost" wrote in message
...
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