View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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