Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Dataexchange suffix .0

Highlighted
Rob Jans
Super Collector

Dataexchange suffix .0

Hi all,

I have an issue with dataexchange.
When I want to create an XML from an XLS there are 2 collomns that only contain digits. In the XML the digits have an suffix .0
I know I had this before with an other customer but do not know how I fixed this.

Hope you can help.

Cheers
Rob
If you think education is expensive, try ignorance
1 REPLY
Loys
Esteemed Contributor

Re: Dataexchange suffix .0

Please change the format for the two columns as "Text" by open the XL select the entire column right click -> Format Cells..->Number tab->Category as Text.

Because while converting the XL to XML file : If the value is less it is converted as "integer" and if the value is large it coverts the format to "float" and due to it it adds by .0.
//Add this to "OnDomLoad" event