Forum Discussion
Decimal to Text
Hello everybody, I am trying to load an Excel-Sheet into Dataverse, with a variety of Datatypes, via Dataflow. But i want to load all off them as plain text. All transformational steps should be ...
Ever find a solution? I have the same thing.
Reading a a column in Excel that can either have number or text.
Reading in some of the number it just adds decimal places
ex. 2209.2 in Excel becomes 2209.1999999999998
funny thing is the next line is 2209.3 and it becomes 2209.3000000000002
happens again for 2211.2 and 2211.3 in the same way.
But all the other rows are fine. Bizare.