I'm not really sure what is happening here. I got this data from a larger macro that connects to a SQL database, sums up a bunch of values, then tests for whether or not the final value is less than 8. For some reason this value in cell B2 is testing as if it's less than 8 in the macro.
I extend it out to like 50 digits and it still looks like 8.000000 etc. I assign each value as a Double variable and take the difference and it's exactly 0. Excel < operator seems to think it is not less than 8. But VBA thinks that it is less than 8.
The value in this field for this macro has been equal to '8' at least a thousand times since I created this routine, and I've never had this problem before...the 8 in cell B1 for example doesn't test true for < 8 in VBA...I don't know what else to look for or check to see why it's thinking that B2 is < 8.
I attached a picture I'm not sure if it will work though. Working in Excel 2010 by the way. Thanks in advance.
I extend it out to like 50 digits and it still looks like 8.000000 etc. I assign each value as a Double variable and take the difference and it's exactly 0. Excel < operator seems to think it is not less than 8. But VBA thinks that it is less than 8.
The value in this field for this macro has been equal to '8' at least a thousand times since I created this routine, and I've never had this problem before...the 8 in cell B1 for example doesn't test true for < 8 in VBA...I don't know what else to look for or check to see why it's thinking that B2 is < 8.
I attached a picture I'm not sure if it will work though. Working in Excel 2010 by the way. Thanks in advance.
