16th digit turns to zero

B

Bill C

Need to record sixteen digit numbers in a spread sheet but the 16th
digit automatically turns to zero when I press enter. 15 digits or
less not affected. Am using Excel 2000 Windows 98, numbers general
format. These numbers are credit cards and this problem has wreaked
havoc until I discovered it. Thought it was program bug till I
discovered Microsoft Works does the same thing. Need help!!
 
F

Frank Kabel

Hi Bill
15 digits is the maximum Excel can process as numbers. You may change
the format to 'Text' prior to entering them (I don't assume you want to
do calculations with your credit numbers) or enter the numbers with a
leading apostrophe

Frank
 

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

Excel Changes My Last Digit to Zero 1
entering 16 digit numbers - last digit turns to zero 4
16th digit in the cell changes to a zero?? 2
16 th digit of a number in a cell gets chopped to zero 3
16 digit numbering 8
16th digit changes?? Problem,16th digit changes to a zero.... 2
How to save a 15 digit # in CSV without it changing to a formula? 1
A tough problem for me to crack 4

Top