| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use "paste special" inside a formula?
How can I tell a formula (that calculates other cell values) to return
(paste) only the formula's value and not formula result? In other words, if you double click on the result, you will not be shown the formula, rather the value. Thanks alot!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "paste special" inside a formula?
You would need to use a macro to place the value. range("a2").value=range("a3")*range("a4") -- Don Guillett SalesAid Software "Dov A." <Dov wrote in message ... How can I tell a formula (that calculates other cell values) to return (paste) only the formula's value and not formula result? In other words, if you double click on the result, you will not be shown the formula, rather the value. Thanks alot!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use "paste special" inside a formula?
Cannot be done through a formula.
A cell contains a formula or a value. Copy then Paste SpecialValuesOKEsc. Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 06:29:00 -0800, Dov A. <Dov wrote: How can I tell a formula (that calculates other cell values) to return (paste) only the formula's value and not formula result? In other words, if you double click on the result, you will not be shown the formula, rather the value. Thanks alot!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| range inside RANK formula based on contents of other cells | Excel Worksheet Functions | |||
| How can I place a formula inside another formula? | Excel Worksheet Functions | |||
| Using a value from a cell inside a formula! | Excel Discussion (Misc queries) | |||
Hybrid Mode
