Re: Can I change the 15-digit limit in Excel for numbers ?
From: Bernard Liengme (bliengme_at_stfx.TRUENORTH.ca)
Date: 01/11/05
- Next message: Terri: "templates"
- Previous message: Bernie Deitrick: "Re: How do I cut & paste non-adjacent rows or columns ONLY in auto-fil"
- In reply to: Johan: "Can I change the 15-digit limit in Excel for numbers ?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 09:17:49 -0400
Are they really numbers? Do you do math on them?
If not, then format them as text
If yes, try the XNUMBER add-on (locate with Google)
beat wishes
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Johan" <Johan@discussions.microsoft.com> wrote in message news:5979EC9D-51D8-4BD5-B5AD-372B69446813@microsoft.com... >I work with numbers containing more than 15 digits, when I import it from a > text file Excel rounds the last three digits to zero and I lose my number > (which I need to find it back in a database), how can I modify this ?
- Next message: Terri: "templates"
- Previous message: Bernie Deitrick: "Re: How do I cut & paste non-adjacent rows or columns ONLY in auto-fil"
- In reply to: Johan: "Can I change the 15-digit limit in Excel for numbers ?"
- Messages sorted by: [ date ] [ thread ]
