Use Format, Cells and change the number formatting from Text to General.

--
Jim
"sherroc" wrote in message
...
| Why do I see ###### in a cell rather than the text that is there. The
text
| shows up in the line across the top but not in the cell itself.