XL only calculates to 15 digit precision!
To enter numbers larger then 15 digits, that will *not* be used for
calculation (credit card #'s - part #'s), you can enter an apostrophe ( ' )
first, which will not display in the cell, but will be visible in the
formula bar.
On a larger basis, simply *pre-format* the column to "Text".
Changing the format to "Text" *after* entering the long numbers will *not*
work.
If you truly need to calculate these large numbers, then XL is *not* the
program for you.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
In Excel 2000 numbers in having over 15 digits in a cell
results in each digit from 16 on turn into zeros (0). How
can I enter numbers over 15 digits?
