16th digit of credit card # changes to 0
Posted by Avadakedavra on November 06, 2001 11:13 AM
I use excell to keep track of our company's credit cards. To make the info easy to read I have each credit card number entered in it's own cell. I have formatted the cells to show the number as four 4-digit sets with dashes in between: ####-####-####-####. I I just type all 16 digits continuously, Excel always changes the last digit to zero. I can type the dshes in manually and it works, but i don't want to. How do I get it to stop changing the last number?
Posted by Aladin Akyurek on November 06, 2001 11:23 AM
Format the cells as text before entry. (NT)
Try using th MROUND Function. You will need the Analysis Tool Pack Add-in installed.
Posted by Mark W. on November 06, 2001 11:29 AM
Format your column as "Text" and enter your card no. with hypens (nt)
Posted by Dan on November 06, 2001 11:30 AM
15 digit limit
There is a limitation of 15 significant digits for numbers in Excel. You could try splitting up the number in to four-four digit cells.
hth
Posted by Dan on November 06, 2001 11:34 AM
Or you can format the cells as Text.
Posted by cory mayback on November 06, 2001 12:48 PM
I had this same trouble, and found a solution. It sounds the same as those above.
The issue is that your field is a number field, and the 15 digits is the limit. Excel is rounding off the last number.
This is what I do. I usually am importing the data from some type of .rtf or .txt file. When the Text Import Wizard comes up (I believe it is Step 2 of 3) I scroll to the right until I see the credit card field (column). I click on it, and in the upper right hand section of the window I change the field (or column) type from 'General' to 'Text'.
This will fix the problem.
cory
corymayback@hotmail.com
