How many characters are in the cell ? I have found that if you have alot of
characters in a single cell it will show"#######" instead of the actual
contents. Each cell in a worksheet has a maximum size, I just cannot remember
what it is or where I found it.

"Wendy Farkas" wrote:

In a cell formatted for text, the contents display as #####, whether wrap is
selected or not in the Format options. Widening the column doesn't solve the
problem, as with numerals in number-formatted cells.