ExcelBanter - Copy and Paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy and Paste (https://www.excelbanter.com/excel-discussion-misc-queries/150455-copy-paste.html)

Jman

Copy and Paste

I have cells in column A with formulas in them that show me results "$65"
$12.30 etc. I want to manually copy and paste these results on a different
sheet but i do not want the formula to be also be pasted, because when the
formula is pasted it it show "0" .

Is there a way i can paste the results only without the formula?

Eddie O

Copy and Paste

Alt E S V (is the keyboard shortcut)
or Edit / Paste Special / Values

"Jman" wrote:

I have cells in column A with formulas in them that show me results "$65"
$12.30 etc. I want to manually copy and paste these results on a different
sheet but i do not want the formula to be also be pasted, because when the
formula is pasted it it show "0" .

Is there a way i can paste the results only without the formula?

Jman

Copy and Paste

Thanks Much,, that did it.

"Eddie O" wrote:

Alt E S V (is the keyboard shortcut)
or Edit / Paste Special / Values

"Jman" wrote:

I have cells in column A with formulas in them that show me results "$65"
$12.30 etc. I want to manually copy and paste these results on a different
sheet but i do not want the formula to be also be pasted, because when the
formula is pasted it it show "0" .

Is there a way i can paste the results only without the formula?

All times are GMT +1. The time now is 04:10 PM.