View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Line break in custom date format?

Format the cell(s) to Wrap Text, adjust the row height to accommodate
two rows, and widen the column to suit. Then in Custom format enter:

dddd,<CTRL-Jmm/dd/yy

You only need 4 d's to specify the full day. <CTRL-J gives you the
line break that you are after, although it is difficult to see the
full format string in the format cells panel.

Hope this helps.

Pete

On Dec 8, 7:02*pm, Ivor Big Botty <Ivor Big
wrote:
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.