Maximum length of a number

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ensure that all numbers are 8 digits long 4
Max length for formula 1
Function in Excel to count and list number of entries of text valuesin a row. 2
Calculating towards a target number 2
Maximum word length 9
numbers in Excel 3
How to extract text from number/text cell 6
Excel maximum Row number 2

Top