View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default Custom format for cells

"Liz" wrote in message
...
Hi

I have a custom format that adds text to a date in a cell:

dd-mmm " incl CFO faxed sign-off"

My problem is that the text will not wrap in the cell. Is there some way
to
force a new line in the format, or to otherwise make it wrap in the cell?

Thanks


Do you have to do this with a custom format? If you use a formula to
concatenate your date (in a defined format) and text, it will wrap. For
example:
=TEXT(A1,"dd-mmm")&" incl CFO faxed sign-off"