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
|