Thread
:
Formula displays does not calculate
View Single Post
#
3
Neil Bhandar
Posts: n/a
Norman,
Thanks for the suggestion, I already chked that. Unformulately the cells are
all numeric. Any other ideas?
Rgds,
-Neil
"Norman Jones" wrote:
Hi Neil,
Perhaps the cell is formatted as text?
---
Regards,
Norman
"Neil Bhandar" <Neil
wrote in message
...
Hello:
I just typed a formula in a cell and it displays =A4+J13 (the same formula
calculates fine in a different cell), instead of claculating the value.
Both
A4 and J13 contain numeric data. I try Ctrl+~ to toggle and chk if full
formula mode was ON? but that did not help either.
I also tried looking for feedback through the formula evaluation utility
in
Excel, no help there either, it says cell being evaluated contains a
constant?
Your help is appreciated
Reply With Quote