View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default entering 16 digit numbers - last digit turns to zero

dreamer wrote:
While creating a sheet with credit card numbers I noticed that upon placing
the 16th digit and any after that , the numbers are zeros There are no
fomats in those cells.
Can anyone help?


Assuming you aren't going to be doing math on these values format the
cell as text.

gls858