Service Desk Practitioners Forum
cancel

Dataexchange suffix .0

Highlighted
Rob Jans
Trusted Contributor.

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