View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default I type text into a cell and get pound signs instead

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" wrote:

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.