edit excel formula changes cell not allowing formula to runExcel formula re-calculating unexpectedlyCan one...
What is the generally accepted pronunciation of “topoi”?
What is better: yes / no radio, or simple checkbox?
How does Ehrenfest's theorem apply to the quantum harmonic oscillator?
Proving a statement about real numbers
How to resolve: Reviewer #1 says remove section X vs. Reviewer #2 says expand section X
Is a piano played in the same way as a harmonium?
How to write a chaotic neutral protagonist and prevent my readers from thinking they are evil?
Why does cron require MTA for logging?
In the late 1940’s to early 1950’s what technology was available that could melt ice?
How do we create new idioms and use them in a novel?
How to design an organic heat-shield?
Giving a career talk in my old university, how prominently should I tell students my salary?
What are you allowed to do while using the Warlock's Eldritch Master feature?
What do *foreign films* mean for an American?
How do electrons receive energy when a body is heated?
When Schnorr signatures are part of Bitcoin will it be possible validate each block with only one signature validation?
MySQL importing CSV files really slow
From an axiomatic set theoric approach why can we take uncountable unions?
Professor forcing me to attend a conference, I can't afford even with 50% funding
Should I take out a loan for a friend to invest on my behalf?
What sort of fish is this
How do spaceships determine each other's mass in space?
Why do we say ‘pairwise disjoint’, rather than ‘disjoint’?
What do you call someone who likes to pick fights?
edit excel formula changes cell not allowing formula to run
Excel formula re-calculating unexpectedlyCan one list everything that uses a particular cell in Excel 2010?excel 2010 vba macro ActiveCell.Formula = produces an empty cell when runTable AutoExpansion incorrectly changes formulaExcel: Reference Dropdown Cell in Countif FormulaFormula that looks at value in a cell and depending on what the value isCan Excel 2010 Cell Formula Reference Another Cell For A Portion Of The First Formula?Excel formula to show FORMULAImporting data to Excel does not calculate formulasExcel table inserting old formula in new rows. How can I reset to the new formula?
I am trying to put formulas into excel (2010 & not a new concept for me), however when i go to edit the formula the cell changes and only shows me the formula (not as a formula but as text in the cell) instead of the result I want. the cell format is set to general so there shouldnt be a problem with the cell running the formula. i think i may have quick keyed something the otherday changing my settings and dont know how to fix this problem.
Im not new to excel and know how to click the "show formula" button to see all my formulas. this is not the problem and does not correct the issue. Any help would be greatly appreciated.
microsoft-excel-2010 worksheet-function
asked Aug 8 '13 at 22:09
jarretjarret
31114
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am trying to put formulas into excel (2010 & not a new concept for me), however when i go to edit the formula the cell changes and only shows me the formula (not as a formula but as text in the cell) instead of the result I want. the cell format is set to general so there shouldnt be a problem with the cell running the formula. i think i may have quick keyed something the otherday changing my settings and dont know how to fix this problem.
Im not new to excel and know how to click the "show formula" button to see all my formulas. this is not the problem and does not correct the issue. Any help would be greatly appreciated.
microsoft-excel-2010 worksheet-function
asked Aug 8 '13 at 22:09
jarretjarret
31114
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Isn't this the default behavior of Excel? Show the calculated value, unless the cell is switched to edit mode, at which point the formula is shown?
– ernie
Aug 8 '13 at 22:38
when i edit the formula, all i am doing is adding the "$" to prevent the formula from looking somewhere else. i should still get the same result. unfortunately, once i click on the formula, the cell now only shows my formula and not the result it should. For example, I am using cell B1 to reflect the exact data in cell A1. lets say A1 says "hi." when i first to the formula in cell B1 as "=A1" cell B1 then says hi. when i change the formula to say "=$A$1" the cell should still say "hi" but now the the cell is only text and say =$A$1" i cannot get it to run the formula.
– jarret
Aug 8 '13 at 23:19
just to add. I opened a brand new excel sheet and the funtion works right. the problem is i have already dedicated DAYS to creating the product with over 50 conditional formats, references to different sheets, etc. I cannot move the data and rebuild the links. i need to fix the issue with this book. I am sure I changed something. Even my cell comment are funky...they dont auto format size to show all text and appear 5-10 celss off the origional cell, even after i edit them to be in the right place & size..very frustrating.
– jarret
Aug 8 '13 at 23:31
1
The only way I could get the same type of behavior - cell shows a number, click on it and the number turns to the formula and won't go back to display of value - was by setting the number format of cells to Text, which I'm assuming is not what is going on with your sheets. Weird.
– chuff
Aug 9 '13 at 3:48
add a comment |
I am trying to put formulas into excel (2010 & not a new concept for me), however when i go to edit the formula the cell changes and only shows me the formula (not as a formula but as text in the cell) instead of the result I want. the cell format is set to general so there shouldnt be a problem with the cell running the formula. i think i may have quick keyed something the otherday changing my settings and dont know how to fix this problem.
Im not new to excel and know how to click the "show formula" button to see all my formulas. this is not the problem and does not correct the issue. Any help would be greatly appreciated.
microsoft-excel-2010 worksheet-function
asked Aug 8 '13 at 22:09
jarretjarret
31114
I am trying to put formulas into excel (2010 & not a new concept for me), however when i go to edit the formula the cell changes and only shows me the formula (not as a formula but as text in the cell) instead of the result I want. the cell format is set to general so there shouldnt be a problem with the cell running the formula. i think i may have quick keyed something the otherday changing my settings and dont know how to fix this problem.
Im not new to excel and know how to click the "show formula" button to see all my formulas. this is not the problem and does not correct the issue. Any help would be greatly appreciated.
microsoft-excel-2010 worksheet-function
microsoft-excel-2010 worksheet-function
asked Aug 8 '13 at 22:09
jarretjarret
31114
asked Aug 8 '13 at 22:09
jarretjarret
31114
asked Aug 8 '13 at 22:09
jarretjarret
31114
asked Aug 8 '13 at 22:09
jarretjarret
31114
asked Aug 8 '13 at 22:09
jarretjarret
31114
31114
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Isn't this the default behavior of Excel? Show the calculated value, unless the cell is switched to edit mode, at which point the formula is shown?
– ernie
Aug 8 '13 at 22:38
when i edit the formula, all i am doing is adding the "$" to prevent the formula from looking somewhere else. i should still get the same result. unfortunately, once i click on the formula, the cell now only shows my formula and not the result it should. For example, I am using cell B1 to reflect the exact data in cell A1. lets say A1 says "hi." when i first to the formula in cell B1 as "=A1" cell B1 then says hi. when i change the formula to say "=$A$1" the cell should still say "hi" but now the the cell is only text and say =$A$1" i cannot get it to run the formula.
– jarret
Aug 8 '13 at 23:19
just to add. I opened a brand new excel sheet and the funtion works right. the problem is i have already dedicated DAYS to creating the product with over 50 conditional formats, references to different sheets, etc. I cannot move the data and rebuild the links. i need to fix the issue with this book. I am sure I changed something. Even my cell comment are funky...they dont auto format size to show all text and appear 5-10 celss off the origional cell, even after i edit them to be in the right place & size..very frustrating.
– jarret
Aug 8 '13 at 23:31
1
The only way I could get the same type of behavior - cell shows a number, click on it and the number turns to the formula and won't go back to display of value - was by setting the number format of cells to Text, which I'm assuming is not what is going on with your sheets. Weird.
– chuff
Aug 9 '13 at 3:48
add a comment |
Isn't this the default behavior of Excel? Show the calculated value, unless the cell is switched to edit mode, at which point the formula is shown?
– ernie
Aug 8 '13 at 22:38
when i edit the formula, all i am doing is adding the "$" to prevent the formula from looking somewhere else. i should still get the same result. unfortunately, once i click on the formula, the cell now only shows my formula and not the result it should. For example, I am using cell B1 to reflect the exact data in cell A1. lets say A1 says "hi." when i first to the formula in cell B1 as "=A1" cell B1 then says hi. when i change the formula to say "=$A$1" the cell should still say "hi" but now the the cell is only text and say =$A$1" i cannot get it to run the formula.
– jarret
Aug 8 '13 at 23:19
just to add. I opened a brand new excel sheet and the funtion works right. the problem is i have already dedicated DAYS to creating the product with over 50 conditional formats, references to different sheets, etc. I cannot move the data and rebuild the links. i need to fix the issue with this book. I am sure I changed something. Even my cell comment are funky...they dont auto format size to show all text and appear 5-10 celss off the origional cell, even after i edit them to be in the right place & size..very frustrating.
– jarret
Aug 8 '13 at 23:31
1
The only way I could get the same type of behavior - cell shows a number, click on it and the number turns to the formula and won't go back to display of value - was by setting the number format of cells to Text, which I'm assuming is not what is going on with your sheets. Weird.
– chuff
Aug 9 '13 at 3:48
Isn't this the default behavior of Excel? Show the calculated value, unless the cell is switched to edit mode, at which point the formula is shown?
– ernie
Aug 8 '13 at 22:38
Isn't this the default behavior of Excel? Show the calculated value, unless the cell is switched to edit mode, at which point the formula is shown?
– ernie
Aug 8 '13 at 22:38
when i edit the formula, all i am doing is adding the "$" to prevent the formula from looking somewhere else. i should still get the same result. unfortunately, once i click on the formula, the cell now only shows my formula and not the result it should. For example, I am using cell B1 to reflect the exact data in cell A1. lets say A1 says "hi." when i first to the formula in cell B1 as "=A1" cell B1 then says hi. when i change the formula to say "=$A$1" the cell should still say "hi" but now the the cell is only text and say =$A$1" i cannot get it to run the formula.
– jarret
Aug 8 '13 at 23:19
when i edit the formula, all i am doing is adding the "$" to prevent the formula from looking somewhere else. i should still get the same result. unfortunately, once i click on the formula, the cell now only shows my formula and not the result it should. For example, I am using cell B1 to reflect the exact data in cell A1. lets say A1 says "hi." when i first to the formula in cell B1 as "=A1" cell B1 then says hi. when i change the formula to say "=$A$1" the cell should still say "hi" but now the the cell is only text and say =$A$1" i cannot get it to run the formula.
– jarret
Aug 8 '13 at 23:19
just to add. I opened a brand new excel sheet and the funtion works right. the problem is i have already dedicated DAYS to creating the product with over 50 conditional formats, references to different sheets, etc. I cannot move the data and rebuild the links. i need to fix the issue with this book. I am sure I changed something. Even my cell comment are funky...they dont auto format size to show all text and appear 5-10 celss off the origional cell, even after i edit them to be in the right place & size..very frustrating.
– jarret
Aug 8 '13 at 23:31
just to add. I opened a brand new excel sheet and the funtion works right. the problem is i have already dedicated DAYS to creating the product with over 50 conditional formats, references to different sheets, etc. I cannot move the data and rebuild the links. i need to fix the issue with this book. I am sure I changed something. Even my cell comment are funky...they dont auto format size to show all text and appear 5-10 celss off the origional cell, even after i edit them to be in the right place & size..very frustrating.
– jarret
Aug 8 '13 at 23:31
1
1
The only way I could get the same type of behavior - cell shows a number, click on it and the number turns to the formula and won't go back to display of value - was by setting the number format of cells to Text, which I'm assuming is not what is going on with your sheets. Weird.
– chuff
Aug 9 '13 at 3:48
The only way I could get the same type of behavior - cell shows a number, click on it and the number turns to the formula and won't go back to display of value - was by setting the number format of cells to Text, which I'm assuming is not what is going on with your sheets. Weird.
– chuff
Aug 9 '13 at 3:48
add a comment |
2 Answers
2
active
oldest
votes
From my understanding, the issue is that you have a cell with a formula, you edit the formula, and then when you click off the cell/finish the edit, it's still displaying the formula instead of the calculated value.
The example you mention was to a cell that says "hi". If this is only happening when you have formulas that are referencing cells that are text format, that sounds like it might be a a known issue:
http://support.microsoft.com/kb/213970
Not sure if this applies to 2010?
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
add a comment |
I had this same problem, and my cell was set on Text.
Once I put the formatting back to General it worked fine...
answered Aug 19 '14 at 9:30
ChrisChris
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f629720%2fedit-excel-formula-changes-cell-not-allowing-formula-to-run%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
From my understanding, the issue is that you have a cell with a formula, you edit the formula, and then when you click off the cell/finish the edit, it's still displaying the formula instead of the calculated value.
The example you mention was to a cell that says "hi". If this is only happening when you have formulas that are referencing cells that are text format, that sounds like it might be a a known issue:
http://support.microsoft.com/kb/213970
Not sure if this applies to 2010?
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
add a comment |
From my understanding, the issue is that you have a cell with a formula, you edit the formula, and then when you click off the cell/finish the edit, it's still displaying the formula instead of the calculated value.
The example you mention was to a cell that says "hi". If this is only happening when you have formulas that are referencing cells that are text format, that sounds like it might be a a known issue:
http://support.microsoft.com/kb/213970
Not sure if this applies to 2010?
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
add a comment |
From my understanding, the issue is that you have a cell with a formula, you edit the formula, and then when you click off the cell/finish the edit, it's still displaying the formula instead of the calculated value.
The example you mention was to a cell that says "hi". If this is only happening when you have formulas that are referencing cells that are text format, that sounds like it might be a a known issue:
http://support.microsoft.com/kb/213970
Not sure if this applies to 2010?
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
From my understanding, the issue is that you have a cell with a formula, you edit the formula, and then when you click off the cell/finish the edit, it's still displaying the formula instead of the calculated value.
The example you mention was to a cell that says "hi". If this is only happening when you have formulas that are referencing cells that are text format, that sounds like it might be a a known issue:
http://support.microsoft.com/kb/213970
Not sure if this applies to 2010?
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
answered Aug 9 '13 at 14:45
ernieernie
5,54821927
5,54821927
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
add a comment |
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
was really hoping for that to work...but it didnt. Any other suggestions? I noticed my cell comments i added as well changes formats. the Block should auto fit to show the text, but goes small, when i click "edit comments" the comments block opens up 5-12 cells to the right...i have to drag it back and then edit, real pain.
– jarret
Aug 9 '13 at 16:13
add a comment |
I had this same problem, and my cell was set on Text.
Once I put the formatting back to General it worked fine...
answered Aug 19 '14 at 9:30
ChrisChris
1
add a comment |
I had this same problem, and my cell was set on Text.
Once I put the formatting back to General it worked fine...
answered Aug 19 '14 at 9:30
ChrisChris
1
add a comment |
I had this same problem, and my cell was set on Text.
Once I put the formatting back to General it worked fine...
answered Aug 19 '14 at 9:30
ChrisChris
1
I had this same problem, and my cell was set on Text.
Once I put the formatting back to General it worked fine...
answered Aug 19 '14 at 9:30
ChrisChris
1
answered Aug 19 '14 at 9:30
ChrisChris
1
answered Aug 19 '14 at 9:30
ChrisChris
1
answered Aug 19 '14 at 9:30
ChrisChris
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f629720%2fedit-excel-formula-changes-cell-not-allowing-formula-to-run%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Isn't this the default behavior of Excel? Show the calculated value, unless the cell is switched to edit mode, at which point the formula is shown?
– ernie
Aug 8 '13 at 22:38
when i edit the formula, all i am doing is adding the "$" to prevent the formula from looking somewhere else. i should still get the same result. unfortunately, once i click on the formula, the cell now only shows my formula and not the result it should. For example, I am using cell B1 to reflect the exact data in cell A1. lets say A1 says "hi." when i first to the formula in cell B1 as "=A1" cell B1 then says hi. when i change the formula to say "=$A$1" the cell should still say "hi" but now the the cell is only text and say =$A$1" i cannot get it to run the formula.
– jarret
Aug 8 '13 at 23:19
just to add. I opened a brand new excel sheet and the funtion works right. the problem is i have already dedicated DAYS to creating the product with over 50 conditional formats, references to different sheets, etc. I cannot move the data and rebuild the links. i need to fix the issue with this book. I am sure I changed something. Even my cell comment are funky...they dont auto format size to show all text and appear 5-10 celss off the origional cell, even after i edit them to be in the right place & size..very frustrating.
– jarret
Aug 8 '13 at 23:31
1
The only way I could get the same type of behavior - cell shows a number, click on it and the number turns to the formula and won't go back to display of value - was by setting the number format of cells to Text, which I'm assuming is not what is going on with your sheets. Weird.
– chuff
Aug 9 '13 at 3:48