I’m making a macro to take the date from a table to another one on the same workbook, but for some reason when it does it the values are multiplied like in the image.

Exemple

The multiplications isnt uniform, it seems to be multiplying it to have the decimal places being always “.00”

I was expecting to paste the data just like it was on the other table, instead of multiplying it.

I don’t know if it’s a problem of the macro or a property of table to have the number decimal places to be “.00”, but when i do it manually it works just fine…

I would be glad if someone could help me