Greetings,

I have a macro which copies a column from worksheet A and pastes it in Worksheet B.

How can I create code so that when it pastes the values in Worksheet B it removes all the decimals.

I have changed the format-cells option to 0 decimal places. However, the value still reads as having decimals.

So for example, if I copy the number 95.67. It will show up as 95, but still use 95.67 for the calculations.

I want to get rid of the 0.67.....

Please help

Thanks
Raj