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