software

I formatted cells in a column of text from quot;Genera formatquot; to quot;Text
formatquot; and the information all changed to #####################. Now
I can't seem to get the original text back, I just get the
###############
Can someone tell me how to get the text backlIf the original text appears in the formula bar then changing the cell
format back to General should reset the appear of the cell. If not then the
original entry is gone unless you can use Edit, Undo (or Ctrl-z) a few times
to get it back.

I don't think there is ever a reason to use the Text number format with a
cell containing text.

--
Jim
quot;dickquot; gt; wrote in message ups.com...
|I formatted cells in a column of text from quot;Genera formatquot; to quot;Text
| formatquot; and the information all changed to #####################. Now
| I can't seem to get the original text back, I just get the
| ###############
| Can someone tell me how to get the text backl
|
Generally a string of quot;pound/numberquot; signs means the cell is too narrow to
display what is entered in it.
Try widening the column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;dickquot; gt; wrote in message ups.com...
gt;I formatted cells in a column of text from quot;Genera formatquot; to quot;Text
gt; formatquot; and the information all changed to #####################. Now
gt; I can't seem to get the original text back, I just get the
gt; ###############
gt; Can someone tell me how to get the text backl
gt;