You are being impacted by Excel's limits:
• Number precision 15 digits
What are your actual uses for the 20-digit "numbers"?
If they're some sort of identification or part number...use a number format of Text. Excel will not convert them to numbers.
Does that help?
Bookmarks