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 [image] Using LINQ to replace specific value in DataTable without For-Each Activities Hi, this is the right side (From d In dt_Combined.AsEnumerable() Let ra = d.ItemArray.Select(Function (x) x.ToString.Replace(“-”,“”).ToArray) Select rc = dt_…

Hi @eltmo While Reading the data using Read Range activity Properties panel PreserveFormat → Check [image] [image] How to preserve Format while copying from an excel file Help I am simply reading from an Excel file and writing to a new excel file and it works. I have…

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,Syst…

When copying excel datatable an inserting, it changes the format

Help Studio

ushu (Usha kiranmai) March 16, 2022, 12:13pm 3

@eltmo Try the below one

Topic		Replies	Views
Keep Format - Writing DT Activities excel , activities , question	7	383	April 9, 2025
How to maintain Datatable format while writing in Excel Studio studio , question , activities_panel	5	2154	February 11, 2022
How to copy data into a column in an excel without changing the data format of other columns Studio	3	1495	August 14, 2020
Studio Excel format all Studio studio , question , activities_panel	10	1526	July 26, 2021
Convert value in excel to correct format Studio datatable , excel , studio , question , activities_panel , format	15	1030	June 16, 2022

When copying excel datatable an inserting, it changes the format

Related topics