Automatic Rounding up

[NN]

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.

 

[Mike]

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

 

[NN]

Thanks. But i would like to use these values to run Luhn algorithm. These are
credit card numbers.

 

[David Biddulph]

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.

 

[Dave Peterson]

Take a look here:

http://groups.google.co.uk/group/mi...xcel*+author:peterson&rnum=1#b66240b8b84903f6

or

http://snipurl.com/1g2i8

But the entry still needs to be text.