Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't calculate
The formula is correct, but it will not calculate. I shows the syntax in the
cell instead and does not actually do the calculation. Often, if I cut and paste the data I am working with into a new worksheet it will work, and sometimes I have to do that 3 or 4 times before it will work, but it is a very random issue. One of the other power users in my office has seen the same problem. Has anyone else seen this and is there a fix? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't calculate
Sounds like cell is formatted as text, change to something else and reenter
the formula -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "lindahamilton" wrote in message ... The formula is correct, but it will not calculate. I shows the syntax in the cell instead and does not actually do the calculation. Often, if I cut and paste the data I am working with into a new worksheet it will work, and sometimes I have to do that 3 or 4 times before it will work, but it is a very random issue. One of the other power users in my office has seen the same problem. Has anyone else seen this and is there a fix? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't calculate
Maybe the cell was formatted as Text before the formula was entered:
1. Select the cell 2. Format the cell as General 3. touch F2 4. touch ENTER -- Gary''s Student - gsnu200740 "lindahamilton" wrote: The formula is correct, but it will not calculate. I shows the syntax in the cell instead and does not actually do the calculation. Often, if I cut and paste the data I am working with into a new worksheet it will work, and sometimes I have to do that 3 or 4 times before it will work, but it is a very random issue. One of the other power users in my office has seen the same problem. Has anyone else seen this and is there a fix? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't calculate
several things can do this
format of the cell is text // format-cells- Number-general show formula is selected // tools-options-view-deselt formulas the equal sign is not recognized as equal // select the equal sign and replace it with a new equal sign "lindahamilton" wrote: The formula is correct, but it will not calculate. I shows the syntax in the cell instead and does not actually do the calculation. Often, if I cut and paste the data I am working with into a new worksheet it will work, and sometimes I have to do that 3 or 4 times before it will work, but it is a very random issue. One of the other power users in my office has seen the same problem. Has anyone else seen this and is there a fix? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula won't calculate
Thanks!!!!!
"Paul B" wrote: Sounds like cell is formatted as text, change to something else and reenter the formula -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "lindahamilton" wrote in message ... The formula is correct, but it will not calculate. I shows the syntax in the cell instead and does not actually do the calculation. Often, if I cut and paste the data I am working with into a new worksheet it will work, and sometimes I have to do that 3 or 4 times before it will work, but it is a very random issue. One of the other power users in my office has seen the same problem. Has anyone else seen this and is there a fix? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to calculate 401(k) | Excel Worksheet Functions | |||
Formula won't calculate | Excel Discussion (Misc queries) | |||
Calculate formula only once. | Excel Discussion (Misc queries) | |||
sum formula does not calculate | Excel Discussion (Misc queries) | |||
Formula to Calculate Age | Excel Worksheet Functions |