Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 10th 05, 02:27 PM
Neil Bhandar
 
Posts: n/a
Default 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

  #4   Report Post  
Old January 10th 05, 02:50 PM
Jason Morin
 
Posts: n/a
Default

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
newsC4B6174-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   Report Post  
Old January 10th 05, 10:55 PM
Dave Peterson
 
Posts: n/a
Default

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
newsC4B6174-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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Excell only displays the formula, not the results René Excel Discussion (Misc queries) 3 December 28th 04 03:08 PM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 08:39 PM
Paste is is copying in formula, but display is wrong. Matt Excel Discussion (Misc queries) 2 December 7th 04 08:37 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 11:29 AM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017