Sounds like Excel is set to display formulas.

Press Ctrl+`
That's the button directly below the Esc Key on most keyboards.

tj

"Mindie" wrote:

The formula result does not display in the cell, instead the formula itself
displays in the cell. I have tried different formats but continue to have
the same problems.