custom format for cell with wrap text

  • Thread starter Thread starter goepf
  • Start date Start date
G

goepf

I'd like to format a datum cell with the following custom number format

"Status" mmm

for value 5 it looks like: Status Jan

Now I would like to have that column not that wide and wrap the tex
like:

Status
Jan

Unfortunately I can't get that thing done...

Any idea?

Thanks
 
Highlight the columns (or just the cells that you want this format for).
Go to Format>Cells>alignment and click wrap text and OK
Then while those cells are still highlighted, click Format>Rows>AutoFit.
Rob
 
Format the cell with Custom format: "Status" mmm. Entering 1 into the cell
should display as "Status Jan" in the cell and 01/01/1900 in the formula
bar. Entering 01/01/2004 would also display "Status Jan" (no quotes).

Unfortunately, I don't think you will be able to get the cell to wrap,
you'll just get ####### in the cell if it is too narrow. One way of
overcoming this would be to merge the status cell with the cell in the
adjacent column to the right. Then when you narrow the column it will
"overflow" into the next cell.

Regards

Trevor
 
Back
Top