MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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.