I formatted cells in a column of text from "Genera format" to "Text
format" 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

If 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
"dick" wrote in message
ups.com...
|I formatted cells in a column of text from "Genera format" to "Text
| format" 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 "pound/number" 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

"dick" wrote in message
ups.com...
I formatted cells in a column of text from "Genera format" to "Text
format" 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