| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
See Results of Formula rather than the Formula Itself
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? |
|
#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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
See Results of Formula rather than the Formula Itself
The formula bar always shows the formula, but
CNTRL-~ will toggle the cell cedisplay between result & formula -- Gary''s Student gsnu200712 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
See Results of Formula rather than the Formula Itself
Hi,
Range the cells (highlight them) and the right click on the range choos copy and then right click again and choos paste special and then choos value and click ok. Thanks, -- Farhad Hodjat "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? |
| Reply |
| 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) | |||
![Johnny B[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
