Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score
4 Replies
452 Views
I needed to retrofit a plot to plot every x points - there are about 3000 points distributed evenly over 60 cycles (seconds, here), and I wanted to modify an existing worksheet so that I could change...
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score
4 Replies
452 Views
hmmmm interesting. i tried in on my computer (excel 2007, fresh sheet) and i notice the same thing. For me, it starts exactly at 4.34 going to 4.36. I am not sure why this is happening, must be one...
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score
4 Replies
452 Views
I'm going to keep it simple before delving into the greater part of the spreadsheet, but have you changed for format for the cells so it reflects 2 decimal places only after the number?
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score
4 Replies
452 Views
I went in and maxxed out the decimals, which is where I found that what it displayed as 5 wasn't
tried rounding, same result!
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score
4 Replies
452 Views
You rounded the numbers in column A and you still get 5.00 really being 4.9999999999 ?
That's weird ... i attached a screen cap of what i did. You can see that my 5.00 is truly 5.000000000000000 if...