Thread: Copy and Paste
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eddie O Eddie O is offline
external usenet poster
 
Posts: 18
Default 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?