When I copy date from csv to excel file the date format changes.
CSV date: 9/12/2019
excel date: 12/9/2019
I want the same date in excel as well. How can I do that?
Create one Excel template file with predefined column type and required format and then copy data into it.
1 Like
@lakshman I have column type as “Date” in excel file. Still it displays as 12/9/2019.
Procedure:
- read range from csv file and output to datatable.
- append range from datatable to excel file.
In Excel, we can specify date format also which way we want. Change the format according to yours and then try once.
@lakshman
i have changed the format in the excel file. but still it does not work. the source file is 
the destination file is
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123