Carriage Return in Custom Format

[Guest]

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]

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).

 

[Guest]

Thanks Dave - this worked!

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).