The format to General *is* the solution, but ... I think it's because of the
"Text Bug".

There seems to be a quirk (bug), where in a Text formatted cell of more then
approximately 256 characters, you'll get the ###'s.

Stranger yet, if you keep typing, the true text *returns* when the character
count exceeds 1024.

General format works for the "in-between" character counts.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Biff" wrote in message
...
Format the cells as GENERAL.

From Excel Help: (search Help for limits and specifications)

Length of cell contents (text)... 32,767 characters. Only 1,024 display in
a
cell; all 32,767 display in the formula bar.

Biff

"Terry Lowe" wrote in message
...
I looked all through doc and searched online and cannot find an answer to
this question. I need some experienced help.

I have a cell (a whole column) defined as Text. If the text I type in
the
cell includes an at sign (@) the text field displays as ##### (railroad
tracks) most of the time. I have verified the format is text (and word
wrap
is on) and it doesn't matter if I start the text with an apostrophe or
not.
It also appears to be OK in some text cells but not others. What is the
deal?

Thanks.