When copying excel datatable an inserting, it changes the format

I am copying a datatable from one sheet to another. If the data contains comma, it inserts this ’ in front og the data.
image

It makes it look like this

image

I need the ’ not to appear.

HI @eltmo

This may solve your problem try like this
if you are using Write range of excel activities use write range of workbook and vice versa

And also if possible remove the error in the cell which contains 2788,5 and try again too

Regards
Sudharsan

@eltmo Try the below one

Hi @eltmo

While Reading the data using Read Range activity

Properties panel

PreserveFormat → Check

image

Regards
Gokul

I actually already had the PreserveFormat checked, because it changed up some dates. I just unchecked it, and now it dosnt add the ', but is does change the dates…

Hi @eltmo

can you share the input file.

Try with expression to change the date format in the excel

Use For Each Row in DataTable

Use Assign Activity

LHS → CurrentRow(“Date”)
RHS →

DateTime.ParseExact(CurrentRow("Date").ToString,ArrString,System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("dd.MM.yyyy")

ArrString

DataType → String of Array
Default → New String(){“dd.MM.yyyy”,“dd-MM-yyyy”}

In Default You can declarer any type of date format

Regards
Gokul