Format dates so they are split across two lines

Question

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well).

In other words, between the month and the day I'd like either:

• A soft line break, which makes the day wrap around to the second line only when the cell is too narrow
• A hard line break, such that the day is always on the second line.

The date would preferably be preserved as a number, but if it has to be turned into a string, then so be it.

How do I do this?

For illustration purposes, I did it by hand by pasting into a Word document and rearranging cells. But I'm looking to do this natively in Excel.

I tried adding a newline character in the number format:

mmm \n dd
mmm ^p dd

but none of these did anything (aside from adding an unwanted n or p).

I, of course, also tried Wrap Text and reducing cell width, but that resulted in ####. Apparently, wrap text doesn't work on formatted numbers.

Answer 1

One solution is to place the date in the first cell across the row formatted as mmm. Then add =A1 in A2 and so forth across the second row so they simply reflect the same as the cell above. Then format that row as dd. It ends up looking like this;

If is has to be in the same cell, you will have to use wrap text.

Answer 2

In the custom format use Alt + 0010 for a line break, although then you can't reduce the column width anyway. Still, it might come in useful.