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"
|