Copying values not formula

[Martin]

Hi Group

I have a cell which contains a value which is generated by a formula. I want
to be able to copy that value elsewhere but when I do a copy and paste it is
the formula that gets copied, not the value it generates. How do I copy the
value?

Thanks for any help anyone may be able to give on this one.

 

[The Red Cardinal]

Hi Group

I have a cell which contains a value which is generated by a formula.
I want to be able to copy that value elsewhere but when I do a copy
and paste it is the formula that gets copied, not the value it
generates. How do I copy the value?

Thanks for any help anyone may be able to give on this one.

Use Paste Special from the right click menu, and then select 'Values' from
the options.

 

[David McRitchie]

Hi Martin,
If you want to this often you might want to create a macro so
you can use a shortcut key combination. Suggest Ctrl+SHIFT+V

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

an example of a full macro is in
Paste/Pasting
http://www.mvps.org/dmcritchie/excel/paste.htm#values
If not famililar with installing/using macros see my page
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Use Paste Special from the right click menu, and then select 'Values' from
the options.

I have a cell which contains a value which is generated by a formula.
[clipped] How do I copy [only] the value?