Displaying Cell Contents

  • Thread starter Thread starter ajones1978
  • Start date Start date
A

ajones1978

Why do I have to double click on the contents of a cell in order to view the
text that's written in it? I have already resized the row to accommodate the
text, but it still shows and prints like this: ############
 
The # symbol displays in cells when the column width is not wide enough to
display the number in the cell. This has nothing to do with row height, it's
a column width issue. Double click the line between the column letter of the
column with the # character and the one directly to its right to widen the
column to the longest entry in the column.
 
If it is text and not numbers or negative dates.times, Excel has a problem
with text strings between 255 and 1024 characters when formatted as text.

Re-format to General and you should be OK.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying & Printing cells with lotsa text 2
Auto-adjust row height does not work correctly 2
Printing truncates cell contents 6
Scrolling Within a Cell 1
Setting rows to autofit wrapping text in a cell 1
Cell shows the last typed text, no matter where it is typed 0
Excel Selected Cell's Content Magnification 3
Cell format - wrap text 7

Back
Top