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

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 ?

On Tue, 11 Jan 2005 00:45:02 -0800, "Johan"
wrote:

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

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" wrote in message
...
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 ?