Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show Formula / Hide Formula
I have some data in (for example) column A: 5 49 4 I don't want to see the formula when I enter this formula into A4: =SUM(A1:A3) I want it to show me: 58 And NOT =SUM(A1:A3) I went to Format | Cells | Protection Tab and "Locked" is not checked. I'm at a loss and I cannot get it to show anything but the formula. TIA for any help! DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=400504 |
#2
|
|||
|
|||
DejaVu Wrote: I have some data in (for example) column A: 5 49 4 I don't want to see the formula when I enter this formula into A4: =SUM(A1:A3) I want it to show me: 58 And NOT =SUM(A1:A3) I went to Format | Cells | Protection Tab and "Locked" is not checked. I'm at a loss and I cannot get it to show anything but the formula. TIA for any help! DejaVu Hi DejaVu Try Tools Options View Tab, under Window Options at the bottom, uncheck the formula box -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=400504 |
#3
|
|||
|
|||
hi,
check the cell with the formula to see if there is an apostrophe ' in front of the equal sign. if so remove it. and apostrophe in front of a formula makes the formula show up a text and not a formula. Post back if that is not it. Regards FSt1 "DejaVu" wrote: I have some data in (for example) column A: 5 49 4 I don't want to see the formula when I enter this formula into A4: =SUM(A1:A3) I want it to show me: 58 And NOT =SUM(A1:A3) I went to Format | Cells | Protection Tab and "Locked" is not checked. I'm at a loss and I cannot get it to show anything but the formula. TIA for any help! DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=400504 |
#4
|
|||
|
|||
ToolsOptionsview
uncheck formulas option. "DejaVu" wrote in message ... I have some data in (for example) column A: 5 49 4 I don't want to see the formula when I enter this formula into A4: =SUM(A1:A3) I want it to show me: 58 And NOT =SUM(A1:A3) I went to Format | Cells | Protection Tab and "Locked" is not checked. I'm at a loss and I cannot get it to show anything but the formula. TIA for any help! DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=400504 |
#5
|
|||
|
|||
Make sure the cell is formatted to General (or Number)--anything but Text.
(Format|Cells|number tab) Then select that cell, hit F2 followed by enter. If you still see the formula, make sure you're not viewing formulas: tools|options|view tab|make sure Formulas is not checked. DejaVu wrote: I have some data in (for example) column A: 5 49 4 I don't want to see the formula when I enter this formula into A4: =SUM(A1:A3) I want it to show me: 58 And NOT =SUM(A1:A3) I went to Format | Cells | Protection Tab and "Locked" is not checked. I'm at a loss and I cannot get it to show anything but the formula. TIA for any help! DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=400504 -- Dave Peterson |
#6
|
|||
|
|||
Thanks to all who provided responses. I should have been more specific on what all I had tried. I had already tried to go to Tools Options and Formulas was not checked. I am 100% sure that there is not an apostrophe in front of my formula. Finally - Thanks Dave! The cell was formatted as text. I tried that once before, but I never re-entered the formula. I just assumed it would update automatically. Problem Solved!! Thanks All! DejaVu -- DejaVu ------------------------------------------------------------------------ DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629 View this thread: http://www.excelforum.com/showthread...hreadid=400504 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to show 97.826 as 97.825 | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I get the formula to show the result on the worksheet? | Excel Discussion (Misc queries) | |||
can you hide rows with a formula? | Excel Discussion (Misc queries) | |||
hide column but show chart | Charts and Charting in Excel |