| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
See Results of Formula rather than the Formula Itself
When you click on it, the formula shows up in the cell itself, or up in the
formula bar? You can't change that, if you want to change the formula into the value, you need to copy/edit/paste special and pick values. "Johnny B" wrote: Hi guys is there anyway to actually solidify the results of a formula. For Example, if i click the cell can i see the RESULTS of the formula, rather than the FORMULA ITSELF? For example Column C will say | American Online | But when i click it, all i see is the formula, (=SUBSTITUTE(B3,A3&", ","") ... can i remove the formula and only see the result of the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
| CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
| View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
| Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Threaded Mode
