Getting ### (hash) symbols in text cell instead of text

[Barry]

I am entering text in a cell formatted as text and instead of seeing the text
in the cell when I hit return, all I see is a row of hash symbols ###########

The text is not long - about 35 words and doesn't have any odd characters
other than /

If I double click on the cell I can see the text in the cell (as soon as I
click off the cell it turns back into the hashes.

When I click on the cell I can see the text up on the field on the tool bar.

What gives?

Thanks
Barry

 

[Jim Cone]

Change the cell format to "General".
--
Jim Cone
Portland, Oregon USA



"Barry" <[email protected]>
wrote in message
I am entering text in a cell formatted as text and instead of seeing the text
in the cell when I hit return, all I see is a row of hash symbols ###########

The text is not long - about 35 words and doesn't have any odd characters
other than /

If I double click on the cell I can see the text in the cell (as soon as I
click off the cell it turns back into the hashes.

When I click on the cell I can see the text up on the field on the tool bar.

What gives?

Thanks
Barry

 

[Alex F]

just expand the cell