I have an excel file where ‘Date’ column has values in “MM/dd/yyyy” format. I want to update the dates to save them as “dd-MM-yyyy” format. For this I read excel file through Read Range in a datatable and then For Each Row,
row(“Date”) = CDate(row(“Date”).ToString).ToString(“dd-MM-yyyy”).
Then wrote it back to Excel with Write Range. Value under Date column did change to ‘ddMMyyyy’ format. But some of them shows as “dd-MM-yyyy”(expected) and others show as “dd/MM/yyyy”. Like in below. How do we fix this to them unique.