I have a little bit of trouble with converting data, when I using data exchange. In my excel sheet, my number look like this 1000, but when I make the import it look like this 1000.0, and that’s not what I want. How can I convert this data, so I only see 1000 and not 1000.0 (That’s give me a lot of trouble in zip-code, telephone, mobil number and so on)
This has to do with the field formatting used on the excel side. I'm not 100% sure anymore, however I believe the best way is to format the fields in question as text fields. Just play around with the formatiing and you will be able to figure it out.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Can you maybe attach the excel sheet to this call (of a part of it?)
Maybe it's related to the way that the fields are defined in Excel. Right click on one cell with a value and choose "format cell". Now you see the way the field is defined in Excel. Maybe it's good to change this to "general" (when this is defined like something else).
Can you tell me if this helps and can you maybe attach the excel file?