Line break in custom date format?

  • Thread starter Thread starter Ivor Big Botty
  • Start date Start date
I

Ivor Big Botty

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.
 
You can try this but I don't like how it turns out.

Custom format:

dddd,ALT 010m/d/yyyy

ALT 010 means hold down the ALT key then *using the numeric keypad*, type
010. When you release the ALT key a little square will appear.

Then format to wrap text.

Adjust the row height/column width as needed.

The problem is the column width is set as if the date was all on a single
line.

The column width will be as wide this:

Monday, 12/08/2009

Not this:

Monday,
12/08/2009
 
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-J>mm/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
 
As I live in a different zone and use dd/mm/yyyy for fates - my suggestion
might have to be fine-tuned by you.
The general principal is:
=TEXT(WEEKDAY(TODAY()),"dddd")&", "&TEXT(TODAY(),"mm/dd/yyyy")
Micky
 
Sorry for the missunderstanding.
This one may be the requested formula:
=TEXT(WEEKDAY(TODAY()),"dddd")&", "&CHAR(10)&TEXT(TODAY(),"mm/dd/yyyy")
Micky
 
Add another step to this routine and it becomes a little less bad.

Apply number format that Biff/Pete suggested.
But then go to the Alignment tab
Uncheck Wrap text (if it's checked)
Check shrink to fit
check wrap text

The columnwidth can be narrower (but still doesn't autofit). Setting the
rowheight is also manual.
 
Back
Top