View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Either pre-format the cells as text prior to data entry
or precede each entry with an apostrophe ('). This will
ensure the credit card # is a text string, not a number.
Excel can only handle up to 15 digits precision.

HTH
Jason
Atlanta, GA

-----Original Message-----
I read that Excel displays rounded numbers, though the

actual values will
remain the same for calculations. I'm trying to simply

input a credit card
number (16 digits), and it keeps rounding the last digit

down to zero. I
can't figure out how to stop this from happening. Any

one else know how to
prevent this?
.