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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Try formatting the cell as general.


moonman7 wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)