Automatic Rounding up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel while writing a 16 digit number the last digit is always rounded to
"0". Eg. while writing the number 4030020530156015, the display number is
4030020530156010. Why? however a 15 digit number is displayed as such.
 
It's to do with the way excel handles numbers. Excel handles up to 15 digits
of precision so if you want to use more; credit card No's for example then
prece3d the number with a ' and it will be displayed correctly.

Mike
 
Thanks. But i would like to use these values to run Luhn algorithm. These are
credit card numbers.
 
If you use the MID() function to extract characters from the 16 character
text string, you can do the relevant arithmetic on the digits you've
extracted.
 
Back
Top