This may work for you. But you'll have to manually adjust the
rowheight--autofit won't work.

You could give the cell a custom format of:
mm/dd/yyyy^jhh:mm:ss

Don't actually type ^j, hit and hold the control key while you strike the j key.
(ctrl-j is the same as alt-0010 (the linefeed character).)

Then Format|Cells|Alignment tab
Turn off Wrap Text (if it's checked)
Check Shrink to fit
Turn on Wrap Text
(maybe even center the horizontal positioning)

Adjust the rowheight manually.

Alex wrote:

I have cells in the format of date and time with 2 spaces between the date
and time. I want to wrap them so that the date is on top, and time on
bottom, but they will not wrap. The only thing I can do is individually
enter "alt+enter" for each cell. Any suggestions?

--

Dave Peterson