![]() ![]() ![]() Select the short date format type m/d/yyyy. The Format Cells pane will appear, showing the custom format d-mmm. Right-click on the date and select Format Cells, or press Ctrl + 1 Output: short date format using Number Tools Format CellsĪnother method to change a date into short date format is through Format Cells. The date is instantly displayed in short date format m/d/yyyy. Select Short Date from the drop-down list.įigure 3. Click Home tab, then click the drop-down menu in Number Format Tools. There are two ways to have a short date format: Default date format d-mmm How to format short date? Upon entering a date, the default format is normally in d-mmm format, as shown below.įigure 1. Excel provides different ways of displaying dates, be it short date, long date or a customized date. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |