Wrap a custom number format
 

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

Wrap a custom number format
 

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

Wrap a custom number format
 

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