ExcelBanter - Maximum length of a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Maximum length of a number (https://www.excelbanter.com/excel-worksheet-functions/116823-maximum-length-number.html)

PÃ©

Maximum length of a number

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?

Ron Rosenfeld

Maximum length of a number

On Tue, 31 Oct 2006 03:04:02 -0800, Pé wrote:

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,

From HELP/Specifications:

Number precision 15 digits

and is there a way to avoid this?

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

--ron

All times are GMT +1. The time now is 07:45 AM.