Change date format of cell in excel from dd mm yyyy to yyy mm dd excel version 2013

Question

I have been searching it for an hour but unfortunately nothing found that actually work. I have an excel sheet with a column having date in it. Current date format is dd.mm.yyyy but I want to change date format to yyyy/mm/dd for entire cell.

Answer 1

Hello :)  

Excel’s Format Cells function can quickly convert dd-mm-yyyy to yyyy-mm-dd format.

 Select the dates you want to convert, and right click to display context menu, and select Format Cells from it and then
 in the Format Cells dialog, under Number tab, click Custom from the list, and type yyyy-mm-dd into the Type textbox in the right section.Click OK. Now all dates are converted to yyyy-mm-dd format