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!