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?