Question

Locked

Microsoft Excel 2003 Problem

By malikawan19 ·
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???

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Interesting

by KSoniat In reply to Microsoft Excel 2003 Prob ...

I have the same version of excel and it sure does. If you enter the number proceeded by the " ' " it does not transform it.

Collapse -

This is by design....

by ThumbsUp2 In reply to Microsoft Excel 2003 Prob ...

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.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums