Thank you for responding so quickly!! This worked perfectly. Thanks again.
:-)
--
Tina


"Niek Otten" wrote:

Hi Tina,

This happens if you type the formula in a cell that is already formatted as text.
Format as general and re-enter the formula (F2,ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tina" wrote in message ...
| Sometimes when I type in a formula, the cell displays the formula and not the
| result. How do I get it to show the result instead of the formula? Is this
| a setting somewhere? It doesn't happen all the time.
|
| Thanks in advance!!
| --
| Tina