Copy and Paste

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste data from a column to a row 0
Copy and paste special 2
I can't copy and paste equations 0
Excel 2010 not allowing me to paste as formula 5
Excel formula to copy/paste formula needed please. 4
Hide Formula & Allow Copy 1
data from internet not showing up 6
Copy, paste 2

Top