Things to try:
1) Use CTRL+` (that is the key to the left of 1 on the top row)
2) Reformat the cells as General and press F9 to recalculate
3) retype the formula (remember to begin it with =)
Let us know which one works
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Neal" wrote in message
...
I am use to typing a formula and having it show the results. Now the cell
just shows the formula.
I have clicked "show formula" and this does not help. Also when I copy
(what I think is) a formula it does not update the cells. In other words
it
treats copy as text.
I entered these formulas through the function library and on the popup
window the result is shown.
UGH - I am need to do something simple and this is taking all day.