Or
=TEXT(H8,"m/d/yyyy")&char(10)&TEXT(H8,"h:m:s AM/PM")

=Char(10)
is the same as the alt-enter.

bj wrote:

use a helper cell with the actual date and use
=TEXT(H8,"m/d/yyyy")&" "&TEXT(H8,"h:m:s AM/PM")
change the time and date format to the particulars you want.

"egun" wrote:

Simple Problem:

I have formatted a couple of cells with the "4/23/2007 10:31:39 AM" style
of format, and set the cells to Wrap Text. I want to change the column width
so that the time portion is on the second line and the date on the first.
When I narrow the column, the text doesn't wrap. Instead I get the
"#########" that says the column is too narrow.

How do I get the text to wrap?

Thanks,

Eric


--

Dave Peterson