Line break in custom date format?
Format the cell(s) to Wrap Text, adjust the row height to accommodate
two rows, and widen the column to suit. Then in Custom format enter:
dddd,<CTRL-Jmm/dd/yy
You only need 4 d's to specify the full day. <CTRL-J gives you the
line break that you are after, although it is difficult to see the
full format string in the format cells panel.
Hope this helps.
Pete
On Dec 8, 7:02*pm, Ivor Big Botty <Ivor Big
wrote:
I want to display the date like this: Ddddd, MM/DD/YY
For example 'Monday, 12/08/2009'. *
However, I want a line break after the comma so that the spelled-out day and
date are on different lines in the same cell.
It's harder than it sounds. *In the cell, the value is '12/08/2009'. *But
the format makes it display as Monday, 12/08/2009. *I can't just put an
alt+enter in the middle of the date value, as that value would no longer make
sense.
Is there a code I can put in a custom format that will allow me to insert a
line break?
Thanks, Much.
|