digits

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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.
--
 
Back
Top