Question: how to change date format in excel in a column?
Answer: Select the cells you want to format.
Press CTRL+1.
In the Format Cells box, click the Number tab.
In the Category list, click Date, and then choose a date format you want in Type. ... 
Go back to the Category list, and choose Custom.