| 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 |
| 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 | |||
Threaded Mode
