×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Custom formatting

Custom formatting

Custom formatting

(OP)
I have been using the Custom format for several years such as entering 2 in the cell and reading 2 kg/m3.

In text only format you can wrap text, or use Ctrl Enter to add a line in a text only cell.

Is there a way to wrap the text in a custom cell where the description is too long for the cell width?

i.e Cell input is 2 but cell reads 2 weeks before installation window. (Formatted as 0"weeks before installation window"

Of course I could widen the column or use a smaller font but that would be too easy!

RE: Custom formatting

Not with a custom format. You'll either have to use two cells (too easy !) or use something like =TEXT(2,"0")&" weeks before installation window"

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Custom formatting

Excel doesn't seem to do very well with automated wrapping and  cell heights.  You are correct that <Format><Cells><Alignment><wrap text> will automatically wrap the large value for you, but it is very inconsistent about increasing the row height to fit the full value.  So you'll get

2
kg/m3

but you may or may not be able to see both lines!  With top alignment you might only see "2" and with bottom alignment you might only see "kg/m3".  

One trick I found for this is to set the format vertical alignment to 'center'.  This way if you do wrap and have two lines and Excel doesn't increase the cell height you'll suddenly see the bottom half of the top line and the top half of the bottom line.  This is very UGLY but at least it alerts the viewer that they aren't seeing the correct data until they manually reformat the height for that row.  This saved me once when I found that the important part of the data was hidden on the second line and only the first line was visible because 'general' vertical alignment only showed the top line.  

Also, a trick I use for data like this is set the cell formula to:  

=CONCATENATE(A1, " kg/m3")

Now your text will show up no matter what the value of A1 is (not just 2).  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources