Has anyone ever encountered this?

[Nita]

Hello everyone,
I was trying to help someone copy and paste some text from Word to
Excel. I'm not sure what version of Word or Excel she is using.

Here are the steps she followed:

1. She copied a paragraph from a Word document

2. She toggled to Excel and selected the cell and clicked on paste. At
this point, the text was displayed but spanned multiple cells.

3. Next she tried to format the cell before pasting. She selected the
cell, went to the format menu, selected text and then went to the
alignment tab and clicked the check box for word wrap.

4. She then pasted the paragraph from Word. However, instead of having
the text wrap around the cell, the cell was filled with "#####" This
was strange to me because the text being pasted into the cell was
alphanumeric, not numeric.

5. She tried to change the width and the height of the cell, but it was
still filled with the characters "#####"

I could not duplicate the problem in Office 2003.

Any suggestions would be very much appreciated.

 

[Nita]

I found the answer to this problem (in case it helps anyone in the
future):

If the user formats the cell as "text", it will display text up to 256
characters in the cell. If the number of characters are greater than
256, it will only display "####" .

However, if the user formats the cell as "general", the display is not
restricted to 256 characters.