I have to change the format of entire column in a csv file. The CSV is semicolon separated.
While reading the csv file using Read CSV, the data is displayed as “4.69E+10”, but the expected output is 46878107557.
While opening this file in notepad also, it is displayed as “4.69E+10”.
I have tried the approach mentioned in the below thread, but no luck. The output I am getting is: “="4.69E+10"”
How did you check this?
If you write it to excel, it may be excel matter.
In this case, can you try WriteRangeWorkbook activity, then check the workbook?
I have tried using WriteRange workbook and WriteRange excel but it shows the value as it is (“4,69E+10”).
Please note the character after first digit is comma. it’s not dot as I mentioned in my first post.
Steps to see the expected data: Open the csv file using excel->Data->Text to Columns->delimited with Semicolon.
The above steps shows the data as given in the screenshot. First column is the input and the second one is the one I manually changed to number format in excel.
The challenge is, when I am performing the above steps, since there is comma in the value, it is being considered as two columns. First par will be single digits and the second part of the data is nowhere visible in the excel. And this is not happening for all the rows.
