I'm having a problem with an Excel spreadsheet that has may links and calculations. The program will work on most PC's in our office but I have to PC's that when they access the spreadsheet and load the data it gives them a " Floating Decimal Point Error" I have tried everything I looked up about it but nothing works. Please give me your ideas.
Thanks
Hi, welcome to the forum
To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
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
I can attach the spreadsheet but to load a drawing for pricing those files are quite large. Maybe attach just one drawing to use? Not sure it will work
Upload failed
Screen shot..
Sorry, I cant really see whats going on from a pic (I did look at yours)
We dont need your whole file, just include enough sample data to show what your problem is. as well as showing what you expect
From my experience, the floating point error is handled by rounding the final number off to however many digits are required to lose the small numbers at the end.
For example, with a formula result of 0.000000000295, =ROUND(formula, any integer less than 10) will return 0.000000000 or 0.
If you are dealing with currency, rounding to 2 digits will suffice.
@cathyinaz.... I think the point is: AFAIK, "floating decimal point error" is not an Excel error.
A google search suggests that the message comes from either custom Data Validation or a third-party add-in. We cannot tell you why it displays that message. It might mean that the custom code is expecting accuracy to 2 (or some other number of) decimal places. It might mean something else altogether.
Track down the source of the message, then read their documentation or ask their help desk.
BTW, your uploaded image is useless to me. Not only is a picture not worth 1000 words when it comes to Excel spreadshets, but also I do not see that specific error message anywhere in the image.
I do see green "error" indicators in two cells. First, those are warnings, not "error", despite MSFT's description. Just ignore them if they do not apply to you. Second, I'm not familiar with any green "error" indicator that means "floating decimal point error". Well, not in Excel 2010, anyway. Perhaps such a warning was added to Excel 2016 (or post-2010). Not that I find in online searches.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks