Try formatting the cell as General (or anything but text).
Then reenter the formula.

Or

Try tools|Options|View tab|and uncheck Formulas
(xl2003 menus)




Trev wrote:

When I entered a formula into a cell it stays visible. I have tried several
different styles of format and the only change I have been able to get
resulted in a #ref error. Any ideas would help.

Thanks
Trev

--

Dave Peterson