Maximum length of a number

P

Pé

When trying to import a very large number from a ".txt-file" in excel, excel
does not show the full length of the number.

Example: the number 740747215632121006 is shown as 740747215632121000

Is there a maximum length of numbers in excel, and is there a way to avoid
this?
 
R

Ron Rosenfeld

When trying to import a very large number from a ".txt-file" in excel, excel
does not show the full length of the number.

Example: the number 740747215632121006 is shown as 740747215632121000

Is there a maximum length of numbers in excel,
Click to expand...

From HELP/Specifications:

Number precision 15 digits
and is there a way to avoid this?
Click to expand...

Only be entering (or importing) the value as TEXT.



--ron
 
Top