Making a list of numbers with 16 digits
 

When I enter the numbers, excel makes the last digit zero. for example:
5476480060834825 would be shown as 5476480060834820

Making a list of numbers with 16 digits
 

Precede the entry with an apostrophe ' or format as text BEFORE you enter
the numbers,
Excel has only 15 digits of precision anything after that will be truncated.
I am sure you don't need to do calculations on these numbers, sounds more
like you need to store account/credit card numbers and if that's the case
you can simply use my suggestion


--


Regards,


Peo Sjoblom


"Melinda" wrote in message
...
When I enter the numbers, excel makes the last digit zero. for example:
5476480060834825 would be shown as 5476480060834820