Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Excel cell format problem

Started by familyhistory , Jun 25 2005 09:38 PM

Please log in to reply

#1
familyhistory

Posted 25 June 2005 - 09:38 PM

New Member

Member
1 posts

I have a spread sheet where the first column is credit card numbers--all sixteen digit number. I enter the number, but Excel automatically changes the last digit in the card number to zero, no matter what I do. This is not good in credit card numbers...

I have formatted the cells as numbers with 0 decimals, which it does, but it changes the last digit. I have changed the width of the cell, and tried everything I can think of. What is happening?

Can anyone help me?

Edited by familyhistory, 25 June 2005 - 09:39 PM.