column size in custom format with word wrap

[Doug Glancy]

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug

 

[Gord Dibben]

Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

 

[Doug Glancy]

Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug

 

[Dave Peterson]

I think you're stuck. And you have to resize the rowheight manually, too!

Can you use a helper cell:

=A1&" Year"&CHAR(10)&"monthly"&CHAR(10)&"Payment"

or even:
=text(a1,"#.00")&" Year" &CHAR(10)&"monthly" & CHAR(10)&"Payment"

If you needed to format the number, too.

Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug

 

[Gord Dibben]

Doug

You were clear. I missed the "custom format with line-feeds".

I have tried what you want but can't seem to find a way to get it done.

See Dave P.'s suggestion about entering the line feeds in the cell text via
formula.

Gord

Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some text. I
put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I looked in
Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug

 

[Doug Glancy]

Thanks Dave and Gord.

Doug

I think you're stuck. And you have to resize the rowheight manually, too!

Can you use a helper cell:

=A1&" Year"&CHAR(10)&"monthly"&CHAR(10)&"Payment"

or even:
=text(a1,"#.00")&" Year" &CHAR(10)&"monthly" & CHAR(10)&"Payment"

If you needed to format the number, too.

Gord,

I may not have been clear. I'm putting the line feed in the custom format.
I get multiple lines in the cell as intended, but if I try to autofit the
column down to the visible width of the text, I get the old "########." I
have to widen the column to about the width it would be without wrapping to
be able to see the text.

Does that alter your answer?

Thanks,

Doug

Doug

Use ALT + Enter key to get a line-feed.

Gord Dibben Excel MVP

On Tue, 24 Feb 2004 17:08:54 -0800, "Doug Glancy"

Win 2k, XL 2k

I'm using a custom format that's a General format followed by some

text.
I

put in some line feeds in using alt-0010 and turned on word wrap, but the
column still has to be as wide as if it were all on one line. I

looked
in

Google archives but couldn't find this exact issue.

Is there a solution to this? Here's the actual format:

General "Year[alt-0010]Monthly[alt-0010] Payment"

Thanks,

Doug