Text cell appears with #####'s

  • Thread starter Thread starter Kayden
  • Start date Start date
K

Kayden

I have a cell that has only text in it that I copied and
pasted within the same worksheet. When I pasted it I
changed the text, but as soon as I clicked outside of the
cell I get only pound signs in place of the text. The cell
was pasted with text formatting, but if I change it to
Special-Zipcode or as currency it changes back to text. I
don't like that solution and would like to know why the
cell, when formatted as text, shows only pound signs.
 
Expand the width of the column


: I have a cell that has only text in it that I copied and
: pasted within the same worksheet. When I pasted it I
: changed the text, but as soon as I clicked outside of the
: cell I get only pound signs in place of the text. The cell
: was pasted with text formatting, but if I change it to
: Special-Zipcode or as currency it changes back to text. I
: don't like that solution and would like to know why the
: cell, when formatted as text, shows only pound signs.
 
Kayden

If the cell is wide enough to display the text, it helps in some cases to
format the cell(s) as General rather than Text.

Gord Dibben Excel MVP
 
Back
Top