Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula displays does not calculate
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
No, Norman is asking if the formula cell is formatted as
text. Delete the contents of the formula cell, format it as General, and then re-enter the formula. Jason -----Original Message----- 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 news:DC4B6174-2475-4C2A-9039- ... 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 . |
#5
|
|||
|
|||
Or just format the cell as general, then hit F2, then enter.
Jason Morin wrote: No, Norman is asking if the formula cell is formatted as text. Delete the contents of the formula cell, format it as General, and then re-enter the formula. Jason -----Original Message----- 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 news:DC4B6174-2475-4C2A-9039- ... 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 . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Excell only displays the formula, not the results | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |