Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Excel cell format problem

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
:tazz: 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.

  • 0




    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
Excel stores numbers greater than 15 digits in two pieces, a number and an exponent.

Read this link to view a workaround.

  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP