Forum Discussion
Floating point error when importing data
- 7 years ago
Someone at the office found the answer for my problem. Apparently to highlight the Excel cell with format 'text' is not sufficient enough to set it as text. You first have to trim it. Then this green triangle appears in the corner. When you import that data, it will remove it.
Perhaps this will also solve similar issues for others.
I guess that will become a support ticket then :).
The problem I see is that when I try to change the detect type, it will inserted as a new step. This new step can only placed after the navigation step. On that point, it is already too late. Besides, there are also article codes with .####. These will be changed to .### by your suggestion. Something I don't want to happen either :).
Someone at the office found the answer for my problem. Apparently to highlight the Excel cell with format 'text' is not sufficient enough to set it as text. You first have to trim it. Then this green triangle appears in the corner. When you import that data, it will remove it.
Perhaps this will also solve similar issues for others.