Hopefully you will agree with me when I say that Excel is very flexible and most especially so in how it allows you to use custom formats for myriad values. I think you will find that most custom formulas are very easy to create once you understand the basic way in which custom formats work.
Suppose you would like to create a two line custom format that will format a date such that the abbreviated day of the week is on the first line and the Month and date are on the second line.
This can be done using the custom format ddd mmmm d, but you will have to figure out a way to add a line break between the ddd and the mmmm d. Excel will not allow you to use the Alt + Enter shortcut that you would normally use between your lines.
You must use your numeric keypad to enter the line break you want in your custom format.
Follow the steps below to learn how:
- Select the cells you would like to format.
- Click on the Home tab of your Ribbon.
- Click the small icon at the bottom right-hand side of the Number group to display the Format Cells dialog box.
- Be certain the Number tab is displayed.
- In the Category list, select Custom.
- Delete whatever is in the Type box.
- Key in ddd.
- Hold down your Alt key while you press 0010 on your numeric keypad, which will enter the line feed character. It looks like the portion of the format you keyed in above disappears but it is not really gone. It has just been moved up above what can be displayed in the Type box.
- Key in mmmm d.
- Click the Alignment tab.
- Be certain the Wrap Text check box is selected.
- Click OK.
After setting up your custom format you will need to adjust the row height of the formatted cells so that the entire two lines of the date will display for you.