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

[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 ?

 

[Ron Rosenfeld]

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 ?

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

 

[Bernard Liengme]

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