Carriage Return in Custom Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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).
 
Thanks Dave - this worked!

Dave Peterson said:
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).
Click to expand...
 
Back
Top