ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row Height (https://www.excelbanter.com/excel-discussion-misc-queries/22356-row-height.html)

Dennis B.

Row Height
 
In a cell with row height set at auto-fit, I get an ######### error message
after exceeding a row height of 100 pixels. The problem is not solved even
if I manually change the row height to more than needed to accomodate the
text. Any suggestions?

Dave Peterson

I'm not sure it's a rowheight problem.

If you have a cell formatted as text and have a string that's between 256-1024
(IIRC) characters long, you get those ###'s.

If you format the cell as General, it appears correct.

Any chance???



Dennis B. wrote:

In a cell with row height set at auto-fit, I get an ######### error message
after exceeding a row height of 100 pixels. The problem is not solved even
if I manually change the row height to more than needed to accomodate the
text. Any suggestions?


--

Dave Peterson

Dennis B.

Thanks, Dave. Changing the cell format from text to general solved the
problem. I appreciate the help!

"Dave Peterson" wrote:

I'm not sure it's a rowheight problem.

If you have a cell formatted as text and have a string that's between 256-1024
(IIRC) characters long, you get those ###'s.

If you format the cell as General, it appears correct.

Any chance???



Dennis B. wrote:

In a cell with row height set at auto-fit, I get an ######### error message
after exceeding a row height of 100 pixels. The problem is not solved even
if I manually change the row height to more than needed to accomodate the
text. Any suggestions?


--

Dave Peterson



All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com