Cell text formatting

[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

 

[STrance413]

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.

 

[Dave Peterson]

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