It's due to rounding errors in floating-point arithmetic. Give this a read:
http://support.microsoft.com/kb/214118
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for youAlso, not all members can upload picture files (Company firewalls and stuff)
I am unable to see your pics, but from the sounds of it, take a look at using 1 of teh ROUND() functions
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Formula should evaluate to zero; showing scientific notation instead
Register To Reply
Bookmarks