- 0
Excel won't except ".05721". Floating point issue?
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
Save 96% on Microsoft Office Pro Plus 2021 + Ultimate Excel Bundle Master Class
By News Staff,
- neowin deals
- microsoft office 2021
- (and 4 more)
- 0 replies
- 0 views
-
- 0 replies
- 0 views
-
Microsoft 365 Apps version 2302 resolves issues in Access, Outlook, Project, and Word
By zikalify,
- microsoft
- microsoft 365 apps
- (and 8 more)
- 0 replies
- 0 views
-
- 0 replies
- 0 views
-
Here are all the new features Microsoft added to Excel in February 2023
By Usama Jawad96,
- 0 replies
- 0 views
-
Question
cybertimber2008
This just came across my helpdesk and work and our IT group is stumped.
When a user enters 20000.05721 it changes to 20000.0572099999 in the formula bar.
In our testing we've found that is is always true if the value is between 16384.05721 and 65535.05721 (as long as value to the right of the decimal remains ?05721?).
We've tried Excel 2007 and 2010 and I've tried changing the field type to Number and Scientific with no change. I did find that adding a " ' " mark works though.
Link to comment
Share on other sites
9 answers to this question
Recommended Posts