RE: $$Excel-Macros$$ Reverse of rounding

2010-07-20 Thread Dave Bonallack
Hi, 10 things you should know about binary . . . (Welcome to the world of base 2) Regards - Dave. > Date: Tue, 20 Jul 2010 05:26:21 -0700 > Subject: $$Excel-Macros$$ Reverse of rounding > From: laurence.tha...@navy.mil > To: excel-macros@googlegroups.com > > I ha

$$Excel-Macros$$ Reverse of rounding

2010-07-20 Thread larry
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 , 79, .15 becomes .1501. The other way around this would be rounding. It only changes the values in the first column. Any ideas on what is going on? -- --