I am updating ‘10 March 2021’ value in excel column as 10/03/2021 but value got changed to 03/10/2021 after appending records to excel from datatable.
- Is there any workaround to solve this in existing build?
- How to solve them in excel to avoid issues ?
I have tried this assignment ( CDate(in_value).ToString(“dd/MM/yyyy”)) before adding records in datatable.