Forum Discussion

DouweMeer's avatar
DouweMeer
Impactful Individual
7 years ago
Solved

Floating point error when importing data

So I do understand where a floating point error comes from and stuff. But I can't fix it. The problem exist as we are using the American numbers with the '.' as a decimal. Some of our product code ar...
  • DouweMeer's avatar
    DouweMeer
    7 years ago

    v-cherch-msft 

     

    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.