tag:blogger.com,1999:blog-13918898.post417277567606959491..comments2023-07-20T05:42:53.557-07:00Comments on <img src="http://i.imgur.com/qRFcKXV.jpg"> Rick Upton's Grab Bag: Value of Excel Formula Won't ShowRick Uptonhttp://www.blogger.com/profile/08025570329489102114noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-13918898.post-49061571357586847382013-05-09T11:25:13.149-07:002013-05-09T11:25:13.149-07:00Much to my frustration, I've tried all of the ...Much to my frustration, I've tried all of the tips metioned here with great hope but none of them work. I can see the results of my formula in the cell, but when I click the cell into edit the result, it takes me into the formula and will only allow me to edit the formula not the result. I have similar lookup formulas in other spreadsheets that do not behave this way. I have also copy and pasted those in without success. Any other ideas I can try? (I'm in Excel 2010) Thank youAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-22730618205181112712013-03-28T08:18:01.817-07:002013-03-28T08:18:01.817-07:00Step 2 worked for me as well !Step 2 worked for me as well !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-1971370626856010142013-03-05T09:06:38.509-08:002013-03-05T09:06:38.509-08:00step 2 worked for me too (well after I double clic...step 2 worked for me too (well after I double clicked in the cell after changing format to General) ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-83364135999728931292012-10-17T01:56:10.645-07:002012-10-17T01:56:10.645-07:00Thank you very much. Step 2 worked for me.Thank you very much. Step 2 worked for me.Manosnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-59041825896463787622012-10-17T01:55:31.061-07:002012-10-17T01:55:31.061-07:00Thank you very much. Step 2 worked for me.Thank you very much. Step 2 worked for me.Manosnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-82851272998447836232012-01-04T10:26:39.592-08:002012-01-04T10:26:39.592-08:00Change cell format to General, then click in the c...Change cell format to General, then click in the cell to get the cursor exactly to the left of the = sign (this should be the farthest left you can go in the formula bar), then hit backspace twice, then enterAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-50744953694589018722012-01-02T07:52:41.845-08:002012-01-02T07:52:41.845-08:00Thanks, step 2 helped.Thanks, step 2 helped.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-48626412759402654752011-11-17T08:51:52.106-08:002011-11-17T08:51:52.106-08:00This issue occurred because those cells were initi...This issue occurred because those cells were initially format as text and so will just display whatever text was keyed in.<br />Changing the cells' format to General will fix the issue. Adding and deleting the apostrophe is basically changing the cell from text to general too.<br />Hope this clarify.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-91716640675086697212011-04-26T10:15:07.980-07:002011-04-26T10:15:07.980-07:00This is very helpful. I'm constantly fighting...This is very helpful. I'm constantly fighting this when using Vlookup. THANKS!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-44677036692904161562010-11-08T08:40:05.861-08:002010-11-08T08:40:05.861-08:00omg the apostrophie trick worked for me thanks!!omg the apostrophie trick worked for me thanks!!Anonymoushttps://www.blogger.com/profile/01650243625429999578noreply@blogger.comtag:blogger.com,1999:blog-13918898.post-80090821107407304492010-11-08T08:39:48.045-08:002010-11-08T08:39:48.045-08:00OMG the apostrophie (sp?) trick worked for me!OMG the apostrophie (sp?) trick worked for me!Anonymoushttps://www.blogger.com/profile/01650243625429999578noreply@blogger.comtag:blogger.com,1999:blog-13918898.post-25390203678084765862010-06-18T14:25:54.188-07:002010-06-18T14:25:54.188-07:00I've had success entering the formula in a cel...I've had success entering the formula in a cell that DOES return the formula value (instead of the formula as text)and then dragging to the inoperable cell (answer "yes" to the prompt asking if the destination cell should be replaced). I commonly need to repeat a LOOKUP formula in cells below. If this is the case, I then use the auto fill function to populate columns.geocode100https://www.blogger.com/profile/06960241267951535660noreply@blogger.comtag:blogger.com,1999:blog-13918898.post-82973439001144456802010-05-12T08:44:50.068-07:002010-05-12T08:44:50.068-07:00Saved me! Thanks.Saved me! Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-15438826648639878982010-03-29T03:40:24.743-07:002010-03-29T03:40:24.743-07:00Thanks a LOT! It turns out that we should always c...Thanks a LOT! It turns out that we should always convert the cells into general numbers!)))Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-84275162885744501682009-05-11T00:04:00.000-07:002009-05-11T00:04:00.000-07:00Thanks, this post helped me. Such a silly thing.Thanks, this post helped me. Such a silly thing.Unknownhttps://www.blogger.com/profile/08852533797260833141noreply@blogger.comtag:blogger.com,1999:blog-13918898.post-7673804652482141022009-04-05T12:45:00.000-07:002009-04-05T12:45:00.000-07:00Another solution is to insert an apostrophe (') in...Another solution is to insert an apostrophe (') in front of the equal sign (comments it out and explicitly shows the formula). Hit return and then go in to the cell and delete the apostrophe (hit return). This then shows the value instead of the formula. Why this works or why there is the problem in the first place I don't know.MikeCraighttps://www.blogger.com/profile/14832916630592997884noreply@blogger.comtag:blogger.com,1999:blog-13918898.post-4491455895740269002009-03-12T06:14:00.000-07:002009-03-12T06:14:00.000-07:00Ah, I've been struggling with this for a solid 24 ...Ah, I've been struggling with this for a solid 24 hours. Solution number 3 (cut and paste) seems to work. Hallelujah! Thank you for posting this!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-46789863448216547372009-01-29T10:21:00.000-08:002009-01-29T10:21:00.000-08:00Thanks a bunch Richard for posting this. I had to ...Thanks a bunch Richard for posting this. I had to refresh the values in over 10k cells. You saved me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13918898.post-30085029472596267762008-08-21T18:55:00.000-07:002008-08-21T18:55:00.000-07:00Thanks Todd. I didn't know about that shortcut for...Thanks Todd. I didn't know about that shortcut for Step 1. Sometimes Step 1 won't work and Step 2 is required.Anonymoushttps://www.blogger.com/profile/17236545483224335990noreply@blogger.comtag:blogger.com,1999:blog-13918898.post-75686045095230230192008-08-07T09:16:00.000-07:002008-08-07T09:16:00.000-07:00Hi Rick,I sometimes cause this to happen accidenta...Hi Rick,<BR/>I sometimes cause this to happen accidentally when trying to key in Ctrl+1 and inadvertantly hitting Ctrl+` which is to the left of the "1" on my keyboard. The Ctrl+` command toggles between showing the formula and the formula result.<BR/>Hope that works for you.<BR/>PA, ToddAnonymousnoreply@blogger.com