entering 16 digit number in Excel suffix 0 comes automatically

G

Guest

When I key in beyong 15 digits number in a cell of Excel 2000 or office XP
Excel eats up 16th digit and places a 0 and go-on like that.

Please help me
 
N

Niek Otten

Excel numeric precision is 15 significant digits.
If you don't need to calculate with the number, for example credit card
numbers, make it text by preceding the entry with an apostrophe. The
apostrophe will not show.
Another way is to format the cells as text before entering the numbers.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

16 digits 10
16 digit number entry changes last digit to 0 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How to restrict zeros in a number from 16th digit onwards 5
Number of significant digits allowed in a cell is 15. 2
Number in text format in CSV file 3
Entering a 16 digit number 1
Extracting 7 digit number from alphanumeric string 10

Top