Cell text formatting

  • Thread starter Thread starter moonman7
  • Start date Start date
M

moonman7

Hi,

I am working with cells that are formatted as Text and
set to Wrap. However, when I enter text that wraps to
multiple lines, and I move focus off of that cell, all
that appears there are ##################### characters. If I select
the cell again, I can see that the data still exists there.

Has anyone seen this? If so, what causes this? And how
does one fix this?

Thanks in advance,

Tom
 
The # symbol indicates that the value in the cell is too wide for the
column. Autofit your column by placing your pointer in between the
column at the top ie (between A and B) and when it turns into a double
arrow move to the right increasing the pixels.
 
Try formatting the cell as general.

Hi,

I am working with cells that are formatted as Text and
set to Wrap. However, when I enter text that wraps to
multiple lines, and I move focus off of that cell, all
that appears there are ##################### characters. If I select
the cell again, I can see that the data still exists there.

Has anyone seen this? If so, what causes this? And how
does one fix this?

Thanks in advance,

Tom
Click to expand...
 
Back
Top