Paste values without formatting

[NichoD]

Hello,

I am trying to copy data from an SQL Data base and paste into my spreadsheet. When copying and pasting manually all values are formatted correctly, and I do not get any pasting options. When trying to paste using VBA the values are falsely formatted. In the data base the values are formatted as "10,0000" which should be stated as 10,00 in excel. Instead it is formatted as 100 000.

How can I using VBA paste it correctly?

Kind Regards.

 

[Joe4]

Please post the code that you are using for us to see.
Please be sure to use the Code Tags when posting your code. If you do not know how, see here: How to Post Your VBA Code