wrap long format date cell

K

krojc

Hello,

Is there a way to wrap the long date format. [$-424]dddd, dd.mm.yy.
I want the date to be wrapped under the day, but the cell format wrap
does not do that. Merging more cells, concatenate or text () is not an
option.

Instead of wednesday, 05. july 2006 written horizontaly in want it
like:

wednesday,
05. july 2006

Thanks.
 
D

Dave Peterson

You can use a custom format of:

dddd(ctrl-j)dd. mmmm yyyy
(hit and hold the ctrl key while striking the j key)

Toggle wrap text (format|cells|alignment tab)

And adjust the rowheight manually.

Be aware that you'll still need to keep the columnwidth wide enough for the
whole string--excel just ignores the alt-enter within the custom format.



Hello,

Is there a way to wrap the long date format. [$-424]dddd, dd.mm.yy.
I want the date to be wrapped under the day, but the cell format wrap
does not do that. Merging more cells, concatenate or text () is not an
option.

Instead of wednesday, 05. july 2006 written horizontaly in want it
like:

wednesday,
05. july 2006

Thanks.
Click to expand...
 
K

krojc

Thank you, it works. I tried that myself, but never considered
adjusting the height of the cell in order to see the date itself. Is
this then only "half" wrap and should be reported as a bug?

Thanks, again.
 
Top