Line break in custom date format?
 

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.

Line break in custom date format?
 

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

--
Biff
Microsoft Excel MVP


"Ivor Big Botty" <Ivor Big wrote in message
...
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.

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.

Line break in custom date format?
 

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


"Ivor Big Botty" 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.

Line break in custom date format?
 

Sorry for the missunderstanding.
This one may be the requested formula:
=TEXT(WEEKDAY(TODAY()),"dddd")&", "&CHAR(10)&TEXT(TODAY(),"mm/dd/yyyy")
Micky


"Ivor Big Botty" 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.

Line break in custom date format?
 

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.



"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Ivor Big Botty" <Ivor Big wrote in message
...
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.

--

Dave Peterson

Line break in custom date format?
 

That's much better.

--
Biff
Microsoft Excel MVP


"Dave Peterson" wrote in message
...
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.



"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP

"Ivor Big Botty" <Ivor Big wrote in
message
...
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.

--

Dave Peterson