You sure it isn't ######## that you see?

I usually change the format to General, but anything but Text should work.

My solution is very similar to yours.

LindaC wrote:

I am working on a spreadsheet that was created in 2003 that has text in a
cell. Everything (formula's, etc) is working great except for any cells that
were "text". They show as ***************. I have to change it to special
and then the text is displayed. Any solutions or knowledge would be
appreciated. Thanks.

--

Dave Peterson