Since the data was hard entered, typed directly, there shouldn't be any extra digits hanging around. There are differences in the cell formats for the two sheets and then throw in what ever format I am using for the array, of course I should be expecting something odd.
On Jul 20, 10:12 am, Stuart Redmann <dertop...@web.de> wrote: > 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
