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 news 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 reenter 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 newsC4B617424754C2A9039 ... 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 reenter 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 newsC4B617424754C2A9039 ... 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) 