Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format for cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format for cells
When entering the format, touch CNTRL-j just before the double quote. This
will insert a hard return in the forrmat. You STILL nedd to format the cell as wrap and insure it is "big enough" -- Gary''s Student - gsnu200760 "Liz" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format for cells
Thanks so much, that works perfectly.
"Gary''s Student" wrote: When entering the format, touch CNTRL-j just before the double quote. This will insert a hard return in the forrmat. You STILL nedd to format the cell as wrap and insure it is "big enough" -- Gary''s Student - gsnu200760 "Liz" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom format for cells
Thanks Stephen.
I could have put anther column in, but that means 1 more column for each column of dates, and then they would have to be hidden etc. It would have been easier just to type the date in. This way, I ( and other users who may not know to unhide / hide the columns) just need to type the date in the cells with this format. "Stephen" wrote: "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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMAT Cells - Custom | Excel Discussion (Misc queries) | |||
Custom format for cells | Excel Discussion (Misc queries) | |||
Format Cells Custom Forumula? | Excel Discussion (Misc queries) | |||
custom cells format | Excel Discussion (Misc queries) | |||
Custom Format Cells | Excel Discussion (Misc queries) |