View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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