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

J

Johan

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

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

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
 
Top