Automatic Rounding up
 

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.
--
NN

Automatic Rounding up
 

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" wrote:

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.
--
NN

Automatic Rounding up
 

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


"Mike" wrote:

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" wrote:

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.
--
NN

Automatic Rounding up
 

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.
--
David Biddulph

"NN" wrote in message
...
Thanks. But i would like to use these values to run Luhn algorithm. These
are
credit card numbers.
--
NN


"Mike" wrote:

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" wrote:

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.
--
NN

Automatic Rounding up
 

Take a look he

http://groups.google.co.uk/group/mic...6240b8b84903f6

or

http://snipurl.com/1g2i8

But the entry still needs to be text.




NN wrote:

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

"Mike" wrote:

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" wrote:

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.
--
NN

--

Dave Peterson