Hi Mindie

two possible problems
first check tools / options / view and ensure that formulas is not ticked
second it is possible that the cell has been formatted to text - select a
cell from a new sheet and choose copy, now select your formulas and choose
edit / paste special - Add ... you then might need to choose edit / replace
and type a = in both the find and replace lines and do a replace all.

hope this helps
Cheers
JulieD

"Mindie" wrote in message
...
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.