Convert text to number cDec(xCell.Value)

For some reason when I am copying some numbers it pastes them as text and later down the road those cell values won't work in needed calculations

Is there a way to either convert the paste destination with some sort of special "values" paste.... or to tweek/fix the range/for each/cDec/xCell lines I found from the net that doesn't seem to be working

Please Login or Register  to view this content.

I had to try a few things but the multiply idea was a good starting place and below is what worked. I also had issues with keeping the "xcell" I am thinking something with the formatting with cell.value vrs xcell.value was throwing it all goofy ... but changing it to cell.value fixed the other problem

Please Login or Register  to view this content.