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
|