Can I change the 15-digit limit in Excel for numbers ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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 ?
Click to expand...

AFAIK, the only way is to import the numbers as TEXT.

If you need to use these values in calculations, then Excel is probably not the
best program to use.


--ron
 
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
 
Back
Top