This problem may be commented on this forum before, without my recognition. I have written a Macro to copy large amount of data from a third party application and paste this info into my spreadsheet. To locate the info in the third party application and place it correctly in my spreadsheet works, but the “Macro executers Paste function" interprets comma as thousand separator and not as decimal point as the third party format is. When I paste with the “manual paste, - Ctrl-V" function in Excel, it comes out right;

I have isolated the problem to the following test;

If I have a content in the clipboard like,

12,345
67,89

And opens an empty Excel worksheet and paste the content into A1:A1, that comes out nice.

However, if I record a Macro just to paste the clipboard content into the default pair of cells, it comes out like this,

12345
6789

Does anyone have a suggestion how to fix this?