Force Excel Dates to ISO Format yyyy-mm-dd
Posted on 2014-01-15
I am running excel 2013 for windows. I was wondering if there was a way to force excel to format dates in ISO format automatically every time a date is entered.
To clarify, I export a csv file from a PowerSchool, which is for schools. From these csvs, I need to upload them to another site for reporting purposes. This site requires all dates to be in ISO (yyyy-mm-dd) format.
I know I can go in and manually format these cells, but sometimes there are alot of columns with these reports. In addition, every time any cell in the report is formatted incorrectly, the upload fails and you have to reformat the dates again in the csv because the changes never stick.
ANy help is appreciated.