I have a CSV file (no choice in how I receive it) that has a column of CUSIPS (numeric identifiers that identify stocks) and a list of dates in MM-DD-YYYY format. I need to change the date format to YYYY/MM/DD. I can do this easily if I open in excel but then excel removes leading zeros and converts all the CUSIPs to scientific notation which then makes any output unreadable by the application that I upload into.
Anybody have a work around for how I can change the date format while maintaining the integrity of the CUSIPs?
Bringing in the CUSIP column as text like that keeps those in their original form. The date column did not change format but I was able to adjust that in excel and maintain the text format of the file. Thanks again!!