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
Question Unanswered
Icons, favicons and merch graphics on Squarespace: my workflow for getting
1 helpful
0 replies
0 helpful
20 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
Discussion
Network Printer Works for Everyone Except Me
0 helpful
10 replies
0 helpful
4 replies