Question Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I enter the number "8260130340311466" in Excel it changes the cell content to 8260130340311460 (changes the last digit from 6 to 0) No matter what format I select it changes the content. I don't want to set this number as text. Any clues why Excel doing that???
3 replies
by malikawan19 Accepted solution
Clarifications
by ksoniat Accepted solution
I have the same version of excel and it sure does. If you enter the number proceeded by the " ' " it does not transform it.
by thumbsup2 Accepted solution
Excel 2003 can only retain AND display 15 significant digits and any digit after that is changed to a zero. This is by design and there is no fix for it.
http://support.microsoft.com/kb/158071
This is UP from the 11 significant digits that Excel 2002 and previous versions could display.
http://support.microsoft.com/kb/65903
If you want something more powerful, Excel isn't the product for you.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies