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.