I have used the custom format to portray a date as Monday, 24 April 2007 in a
cell by using dddd, dd mmmm, yyyy
But what I want is for Monday to be on the first line by itself and 14 April
2007 to be on a second line. In other words, is there some way to enter ALT
ENTER after Monday in a custom format?

Select your range
Format|Cells|Number Tab|Custom Category
dddd,$dd mmmm, yyyy
But don't type the $. Instead, hit ctrl-j

Then to the Alignment tab.
Click the Shrink to fit box (do this first)
then click the Wraptext box (do this second)

You'll have to adjust the rowheight manually. And maybe the columnwidth, too.

I'd center the text, too. It looks nicer (I think).

Sam wrote:
>
> I have used the custom format to portray a date as Monday, 24 April 2007 in a
> cell by using dddd, dd mmmm, yyyy
> But what I want is for Monday to be on the first line by itself and 14 April
> 2007 to be on a second line. In other words, is there some way to enter ALT
> ENTER after Monday in a custom format?

--

Dave Peterson

Thanks Dave - this worked!

"Dave Peterson" wrote:

> Select your range
> Format|Cells|Number Tab|Custom Category
> dddd,$dd mmmm, yyyy
> But don't type the $. Instead, hit ctrl-j
>
> Then to the Alignment tab.
> Click the Shrink to fit box (do this first)
> then click the Wraptext box (do this second)
>
> You'll have to adjust the rowheight manually. And maybe the columnwidth, too.
>
> I'd center the text, too. It looks nicer (I think).
>
> Sam wrote:
> >
> > I have used the custom format to portray a date as Monday, 24 April 2007 in a
> > cell by using dddd, dd mmmm, yyyy
> > But what I want is for Monday to be on the first line by itself and 14 April
> > 2007 to be on a second line. In other words, is there some way to enter ALT
> > ENTER after Monday in a custom format?
>
> --
>
> Dave Peterson
>