View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ivor Big Botty Ivor Big Botty is offline
external usenet poster
 
Posts: 1
Default Line break in custom date format?

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.