Hi
Firstly highlight all the cells you want to change the date format.
Then right click anywhere in the highlighted area and choose format cells.
Then choose Custom.
Then enter the following format: yyyy-mm-dd.
This will reformat all your dates.
Hope this helps.
Good luck.
Tony