Excel: Formatting problem with Text

[rizvir]

Hello,
This behavior is quite strange. In one of the cells of a spreadsheet when I type any text, I get ########### displayed when I move out of that cell. If I change the cell format to "General" from "Text" then the text appears correctly. What could be the reason?

Thanks for any help provided.

RRR.

 

[zoroaster]

Hi Rizvir

I know this is a dumb suggestion, but when you enter a number in a cell that is too narrow to display it, it reverts to '#####' - I know this doesn't usually happen with text though - what happens if you widen the cell?

Laters, Z

"42??? We're going to get lynched!

 

[rizvir]

Hello Laters, Z

I am aware of the situation with numbers but stragely this is happening with text. Further experiment has shown that if the text width is within the width of the cell then it displays OK but if the cell width is less than the text width then I get ###########.
In other words, what happens with numbers is happening with text.

Rizwan.