On 20 Jul., 14:26, larry wrote: > I have a macro where I copy data into an array from one sheet and then > post it in another sheet and there is something odd. .8 becomes , > 799999, .15 becomes .15000001. The other way around this would be > rounding. It only changes the values in the first column. Any ideas on > what is going on?
Have you checked whether the receiving cell has set the same number of digits after the comma? Maybe the superfluous information is just not displayed in the source cell. BTW, the floating point arithmetic imposes the restriction on us that decimal fractions that are no binary fractions cannot be stored as exact values. So what you see is most probably not some kind of "inverse rounding" but just the exact value of the floating point variable. Regards, Stuart -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
