Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select only the result of an equation
How do I select (or copy) only the result of an equation - not the equation
itself? Example: =2+4 This cell will show 6 not the equation. I want to copy the "6" not the "=2+4". Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select only the result of an equation
Copy as usual, go to the destination cell, which may be the same one too,
right click, select Paste Special, tick the Values option, and OK out -- Hth Kassie Kasselman Change xxx to hotmail "Nate MMI" wrote: How do I select (or copy) only the result of an equation - not the equation itself? Example: =2+4 This cell will show 6 not the equation. I want to copy the "6" not the "=2+4". Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select only the result of an equation
Use "Paste special", "Value"
Nate MMI wrote: How do I select (or copy) only the result of an equation - not the equation itself? Example: =2+4 This cell will show 6 not the equation. I want to copy the "6" not the "=2+4". Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select only the result of an equation
I beleive you want to copy the cell (CTRL + C) and then Paste Special and
select Values the OK. Hope thats what your after. Paul "Nate MMI" wrote: How do I select (or copy) only the result of an equation - not the equation itself? Example: =2+4 This cell will show 6 not the equation. I want to copy the "6" not the "=2+4". Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with excel array - select, add and calculate result | Excel Worksheet Functions | |||
equation as text string and its numeric result | Excel Discussion (Misc queries) | |||
select cells that are the result of a search | Excel Discussion (Misc queries) | |||
select numbers from a list and add to optimise result | Excel Worksheet Functions | |||
How to make one column be the result of an equation between two | New Users to Excel |