Thanks for posting back. I hadn't noticed that.

egun wrote:

That didn't work for me because I still get the "######" when I shrink the
column. Since the objective is to shrink the column width, this won't help.

However, I found a wierd workaround. First I set the cells to "Shrink to
Fit". Then, with that still selected, I also set the "Wrap Text" to on. The
"Shrink to Fit" is grayed out, but stays checked. I then shrank the column,
and guess what - the text wrapped just fine!! How's that for unpredictable
behavior.

Thanks for your inputs,

Eric

"Dave Peterson" wrote:

Not so simple answer.

You can get the text to wrap, but you can't get the ######'s to go away if excel
thinks the column is too skinny.

And excel will base the columnwidth on the width before wrapping.

If you want this, then select your range
format|cells|number tab|Custom category
mm/dd/yyyy_hh:mm:ss AM/PM
But don't use the _ character--use ctrl-j

Then change the alignment tab's wrap text to true.

You'll notice that you may have to fit the rowheight automatically, too.

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


--

Dave Peterson