How to Convert Dates in Excel

1. Open the worksheet.
2. Click the cell or a selection of cells.
3. Click the 'Home' tab on the command Ribbon.
4. Click the Dialog Box Launcher in the lower right corner of the 'Number' group. The dialog box opens.
5. Click the 'Number' tab. A list of categories displays.
6. Click 'Date.' A list of date formats displays in the 'Type' box. Examples include March 14, 2001 and 14-Mar-01.
7. Click the date format.
8. Click the down-arrow for the 'Locale (Location).' A menu includes 'English (United States),' for example. The formatted date can translate into other languages.
9. Click the preferred language.
10. Click 'OK.' The dates convert to a different format in the selected cells.