how to change the date format in excel in a column?
['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.', 'Under Type, pick a date format. ... ', 'If you want to use a date format according to how another language displays dates, choose the language in Locale (location).']