digits

[Chris]

I need to be able to add a total of 16 digits in number
for a project i'm working on it needs to be in sequences
but everytime i do that it goes back to my first number
help

 

[David McRitchie]

Hi Chris,
Excel retains only 15 significant digits, if you have an
identification number (ID number) then it should be
entered as text. Credit card numbers are generally
16 digits they are for identification not treated arithmetically.

Format, cells, text or
place a single quote in front of the identification number
to indicate it is text.
--