Entering numbers

J

Jorr

I'm entering long numbers on an Excel 2000 spreadsheet in
a cell set for number format. When I enter a long number,
such as a credit card number (16 digits) Excel changes the
last digit on my number to a 0! I have tried reformatting
the number, but no matter what I do it switches to 0
unless I format the cell as text. What's the deal? If
the number is 15 digits, there is no problem.
 
F

FBC

The latest versions of Excel have a 15-digit precision
maximum. The only way to display the number is in text
format or using in the exponent format (General and
Scientific formats). I'm afraid those are your only
options...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

15+ digit numbers 3
Unknown Number Format 3
numbers convert to formula in csv 1
cell format in Excel 2002 SP3 will not accept long numbers 1
How to save a 15 digit # in CSV without it changing to a formula? 1
Problem entering numbers 3
numbers need to be numbers 4
Stop excel rounding my 16/17 digit numbers 2

Top