Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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?

Format the cells as text before entry. (NT)

Posted by Aladin Akyurek on November 06, 2001 11:23 AM

Try using th MROUND Function. You will need the Analysis Tool Pack Add-in installed.

Format your column as "Text" and enter your card no. with hypens (nt)

Posted by Mark W. on November 06, 2001 11:29 AM

15 digit limit

Posted by Dan on November 06, 2001 11:30 AM

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

Or you can format the cells as Text.

Posted by Dan on November 06, 2001 11:34 AM

Re: 16th digit of credit card # changes to 0

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.