On the Home tab, in the Number group, click the Dialog Box Launcher next to Number. You can also press CTRL+1 to open the Format Cells dialog box. In the Category list, click Date or Time. In the Type list, click the date or time format that you want to use.
- How do I change the date format in Excel to mm/dd/yyyy hh mm?
- How do I format a date in DD MMM YYYY in Excel?
How do I change the date format in Excel to mm/dd/yyyy hh mm?
In an Excel sheet, select the cells you want to format. Press Ctrl+1 to open the Format Cells dialog. On the Number tab, select Custom from the Category list and type the date format you want in the Type box. Click OK to save the changes.
How do I format a date in DD MMM YYYY in Excel?
In the “Number” tab, select the option “Custom.” Then, under “Type,” enter or choose the format “dd-mmm-yyyy.” The same is shown in the following image. If the sample date looks alright, click “OK.”