wrap long format date cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

krojc@email.si - 05 Jul 2006 10:14 GMT

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.

Reply to this Message

Dave Peterson - 05 Jul 2006 13:12 GMT

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,
>
[quoted text clipped - 10 lines]
>
> Thanks.

Signature

Dave Peterson

Reply to this Message

krojc@email.si - 06 Jul 2006 09:59 GMT

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.

Reply to this Message

Dave Peterson - 06 Jul 2006 12:51 GMT

I'm not smart enough to know if it's a bug or by design.

> 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.

Signature

Dave Peterson

Reply to this Message