Hi @jntrk
U can try this to change the date format to MM/d/yyyy
Datatable_variable.AsEnunerable().ToList().ForEach(Sub(row) row(columnName)= Date.ParseExact(row(“ColumnName”),“d.MM.yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/d/yyyy”))
U can try this in a invoke code activitiy.
But when u write the datatable in excel it is better to add the data in text format rather than adding in datetime because of excel cell may be formated in one date format, like they may be formated in dateformat of dd.MM.yyyy but even when u paste the date in format of MM/dd/yyyy it will appear as dd.MM.yyyy.
Before writing the datatable to excel try to convert the date format in excel to.required one either manually or using Balareva activitiy.
Hope the information helps you
Regards
Nived N 
Happy Automation 


