ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrapping text (https://www.excelbanter.com/excel-discussion-misc-queries/243503-wrapping-text.html)

argo

Wrapping text
 
I am working on a spreadsheet that is mostly text. Many of the cells have
quite a bit of text in them. In one particular cell, I get the ##### which
indicate to me that the cell is not wide enough to accommodate the text. I
have deleted and re-entered the text several times. The cell is not merged,
text wrapping is turned on, there are no numbers or formulas or special
formatting in the text. Even by manually dragging the cell border down to
make the cell border bigger, I cannot get the text to appear. Other cells in
the document with a similar amount of text are just fine. Any suggestions?
--
argo

Jim Thomlinson

Wrapping text
 
Is the cell formatted as text. If so try reformatting as general.
--
HTH...

Jim Thomlinson


"argo" wrote:

I am working on a spreadsheet that is mostly text. Many of the cells have
quite a bit of text in them. In one particular cell, I get the ##### which
indicate to me that the cell is not wide enough to accommodate the text. I
have deleted and re-entered the text several times. The cell is not merged,
text wrapping is turned on, there are no numbers or formulas or special
formatting in the text. Even by manually dragging the cell border down to
make the cell border bigger, I cannot get the text to appear. Other cells in
the document with a similar amount of text are just fine. Any suggestions?
--
argo


Rick Rothstein

Wrapping text
 
Copy/Paste the text in that cell into a reply to this message so that we can
test what you are talking about.

--
Rick (MVP - Excel)


"argo" wrote in message
...
I am working on a spreadsheet that is mostly text. Many of the cells have
quite a bit of text in them. In one particular cell, I get the #####
which
indicate to me that the cell is not wide enough to accommodate the text.
I
have deleted and re-entered the text several times. The cell is not
merged,
text wrapping is turned on, there are no numbers or formulas or special
formatting in the text. Even by manually dragging the cell border down to
make the cell border bigger, I cannot get the text to appear. Other cells
in
the document with a similar amount of text are just fine. Any
suggestions?
--
argo




All times are GMT +1. The time now is 09:04 PM.

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