I want to display a date in a cell formatted "ddd d mmm", but I want the
resulting test to wrap onto 2 lines. It's refusing to do so. Any ideas?
Thanks
Rob

You can do it, but it won't behave very nicely.

I'm gonna assume that you want the break between the ddd and d.

Format|cells|Number tab
Custom format
dddXd mmm
But instead of typing the X, hit ctrl-j
(ctrl-j is the same as alt-enter)

Now to the Alignment tab
make sure that Wrap text is checked

Then back to excel.

You'll have to make the rowheight deeper -- it won't react to autofitting.

And if you squeeze the column width too much, you'll see #####.

And those are based on the width of the text--not including wrap text!

Not quite the same, huh?

Rob wrote:

I want to display a date in a cell formatted "ddd d mmm", but I want the
resulting test to wrap onto 2 lines. It's refusing to do so. Any ideas?
Thanks
Rob

--

Dave Peterson

very nice - a useful tip.
--
Gary''s Student
gsnu200712