Paste two decimal number in excel without extra decimal places appearing

[jeffery_frick]

I have a vba macro that takes data from one workbook and pastes it into another workbook. In doing this I have declared a few variables of type single (I only need two decimal precision). However, when I copy the values from the cells on the source workbook and paste them into the target workbook, the numbers end up having 12 decimal places. Ultimately, this extra precision causes my totals to be off by .01 or more after a while. I have tried rounding the number as I pull it off the source workbook into the variable, but that didn't matter. How do I solve this problem?

Code for pulling data from source workbook:

Please Login or Register  to view this content.

code for pasting the data into the target workbook:

Please Login or Register  to view this content.

Thanks

[shg]

Numeric values on worksheet are always Doubles, and Singles in code will get converted to Doubles when they are saved to the sheet. The Double representation of, for example, 1.1, is not the same as the Single representation (it's a lot closer, though still not precise).

You should declare your variables as Doubles in your code, and round as you are doing. If that doesn't solve your problem, post a workbook.

[jeffery_frick]

Thanks, worked perfect.