Paste this number into your Excel : 498086705447011044810
It changes last 5 digits to 0. So after pasting this is what you see : 498086705447011000000
I don't think this number is over the range specified by Microsoft. Refer this : http://office.microsoft.com/en-us/ex...010342495.aspx
Can anyone tell me what's going on ? Why is Excel changing the original number.
excel can only take 15 digit numbers. After that, it replaces the remaining numbers with 0
from your own link...
FEATURE MAXIMUM LIMIT
Number precision 15 digits
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
excel can only take 15 digit numbers. After that, it replaces the remaining numbers with 0
from your own link...
FEATURE MAXIMUM LIMIT
Number precision 15 digits
Ok, thanks for pointing this out to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks