Avoiding Floating Point

[Boris7265]

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have transferring data from one spreadsheet onto another via macro and the floating point is changing datas on the spreadsheet where data have been transferring. Please, how can I avoid the floating point?<o></o>
The data should be imported on the spreadsheet without changing due we submit it to clients (large <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on"><st1:country-region w:st="on">usa</st1:country-region></st1lace> banks is this case).The data that have been changed. For examples, all data in column c consist 17 digits and it is like 6011004975859139 (reference numbers) and this number has been transferred onto another spreadsheet as 6.011E+15 that is different number to the first spreadsheet.
<o> </o>
Any help will be greatly appreciated.<o></o>
<o> </o>
Thank you,<o></o>
<o> </o>
The Best Regards <o></o>
<o> </o>

 

[Jonmo1]

This isn't a problem with floating point precision.

It's a limitation of Excel that it can't/won't calculate more than 15 digits.
Any digit beyond 15 is changed to a 0


Resolution is to keep the values as TEXT, not numbers.

 

[Boris7265]

Thank you very much Jonmo1.

Ok, I didn't know that . I have tried to declare the variable as the string , but I have had the same result .
I am not very knowledge in vb code, would you be so kind to give me some hint or peace of code how can I copy -paste column c to another spreadsheet avoiding the floating point or some advice

Thank you very much in advance.

The Best Regards.

 

[Jonmo1]

A basic copy/paste should retain the text formatting of the cells.


Can you post the code you're currently using?