16+ digits truncate in Excel

[lurc]

As I type 16+ digits in Excel, I am using Excel 2002, it will truncate the
last digit to zero, say type 1234567890123456, it becomes 1234567890123450
after ENTER pressed.

I know it can be resolved to set unit format to TEXT, is there still any way
to keep it as numeric instead of text?

Thanks.

 

[David McRitchie]

Excel maintains 15 significant digits that is a specification limit.
To get around it you have to use text and use subroutines to work
with the numbers.

 

[Jerry W. Lewis]

Clarification: The only numeric data type in Excel that fully resolves
more than 15 decimal digits is the VBA decimal data type. As David
noted, you would have to pass the values to VBA as text and then use
CDec() to convert to the Decimal data type.

Jerry

Excel maintains 15 significant digits that is a specification limit.
To get around it you have to use text and use subroutines to work
with the numbers.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

As I type 16+ digits in Excel, I am using Excel 2002, it will truncate the
last digit to zero, say type 1234567890123456, it becomes 1234567890123450
after ENTER pressed.

I know it can be resolved to set unit format to TEXT, is there still any way
to keep it as numeric instead of text?

Thanks.