Leading '0' drop off from date format 'MM/DD/YYYY' in csv file after opening in Excel
Leading '0' drop off from date format 'MM/DD/YYYY' in csv file after opening in Excel
User wants to load the csv file data into peoplesoft which includes date field
When they open in excel, leading zero gets removed.
How to retain leading 0 or can we control it by code/file layout