I type text into a cell and get pound signs instead

[r1971]

I have free text fields in a spreadsheet I developed so co-workers can
provide status updates on their work. Occasionally, when someone types in a
status update, the cell only displays pound signs (################). If I
select that cell, the text appears in the formula bar, but the active cell
just shows pound signs. It doesn't seem to be related to the amount of text
that was typed, because other text entries are longer but they display just
fine in the cell. How do I fix this? Thank you.

 

[Mike Rogers]

If there is nothing in the cell to the right it will usually run on across,
if you want to only display within the cell text is entered and get the pound
signs it is usually because the column is to narrow, just widen it and you
can see all the text.

Mike Rogers

 

[r1971]

Thanks for the reply, but I have "Word Wrap" activated. So that should
alleviate that problem. However, I did go ahead and widen the column to the
width of my monitor to see what would happen...no luck!

 

[מיכ×ל (מיקי) ×בידן]

Just out of curiosity - what happens when you change the number format - if
that cell - to "General" !?
Micky

 

[Dave Peterson]

Excel has a problem with cells formatted as text where the value is between 255
and 1024 characters long. Formatting as General will fix the display.

 

[r1971]

That did it...thank you!

Just out of curiosity - what happens when you change the number format - if
that cell - to "General" !?
Micky

 

[r1971]

That did it...thank you!!

Excel has a problem with cells formatted as text where the value is between 255
and 1024 characters long. Formatting as General will fix the display.