Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Formula Results to Actual Data Values
Is there a way to convert the result of a formula into an actual data value
instead of the cell containing the formula itself when copied? Any help would be appreciated. Thank You. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Formula Results to Actual Data Values
CopyPaste SpecialValuesOKEsc
Gord Dibben MS Excel MVP On Tue, 15 May 2007 17:29:00 -0700, RSJ145 wrote: Is there a way to convert the result of a formula into an actual data value instead of the cell containing the formula itself when copied? Any help would be appreciated. Thank You. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Formula Results to Actual Data Values
Copy the cells with the Formula...
Right Click on the mouse, go to Paste Special... Then Click on Values... and press ok "RSJ145" wrote: Is there a way to convert the result of a formula into an actual data value instead of the cell containing the formula itself when copied? Any help would be appreciated. Thank You. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Formula Results to Actual Data Values
I forgot to tell you that you have to copy the data first
"RSJ145" wrote: Is there a way to convert the result of a formula into an actual data value instead of the cell containing the formula itself when copied? Any help would be appreciated. Thank You. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Formula Results to Actual Data Values
Try this:
Select the formula cells From the Excel main menu: <edit<copy Select the destination cells <edit<paste special.....Check: Values......Click [OK] Does that help? *********** Regards, Ron XL2002, WinXP "RSJ145" wrote: Is there a way to convert the result of a formula into an actual data value instead of the cell containing the formula itself when copied? Any help would be appreciated. Thank You. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Formula Results to Actual Data Values
Thank you everyone.
I knew it was something simple. "RSJ145" wrote: Is there a way to convert the result of a formula into an actual data value instead of the cell containing the formula itself when copied? Any help would be appreciated. Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting results from formula to text in a new column | New Users to Excel | |||
Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
Using formula results as values in other formulae | Excel Worksheet Functions | |||
Converting an object in Excel into an actual cell | Excel Discussion (Misc queries) | |||
Converting "ADDRESS" Results to data referanced | Excel Worksheet Functions |