Karen

Two possibles here.

1. View Formulas is enabled.

Hit CTRL + `(above Tab key) to toggle off/on.

2. The cell(s) was/were pre-formatted as Text.

Changing to General is not enough. You must hit F2 then ENTER key.


Gord Dibben MS Excel MVP

On Tue, 13 Jun 2006 12:27:02 -0700, Karen
wrote:

The cell was General when I entered the formula. The formula does NOT work
in other cells on the worksheet.

"Elkar" wrote:

Did you re-enter the formula after changing the format to General? Text
values remain as text until re-entered even if the Cell Format changes.

If that doesn't solve the problem, does the formula work in other cells on
the same sheet? Do other formulas work in that cell?

HTH,
Elkar


"Karen" wrote:

I have entered this formula into a cell formatted as General. It will not
show the date/time. It is showing the text of the formula.

Please help!