Wrapping Date/Time in Cell

[Jeffrey Mahoney]

I want to display the date on the first line and the time on the second line in a cell.

Since Excel won't wrap a number in a cell and Date/Time values are numbers, all you get is ### in a column when the number is too long for the column width.

Is there any way to add a hard return in the number formatting string?

 

[6StringJazzer]

an extra step needs to be taken to make the date time wrap correctly.

Of many suggestions I tried, this is the first thing that worked for me. Thanks!