Why does excel replace my 16th number with a zero?

D

DebR

I am trying to type 16 numbers in a column, but no matter what the last
number i type is, excel changes it to 0. I've tried formatting the cell as
text and custom, but nothing is working. How can I make it stop?
 
J

Jacob Skaria

Enter them in cells preformatted as Text or with a leading apostrophe
('). Excel is limited to 15 decimal digits of precision, so to work with
numbers
with more digits than that will require you to use string functions to
manipulate parts of the numbers.

If this post helps click Yes
 

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

Word macro that can call cells out of Excel for a find and replace 0
MS Word List Bug 0
My custom number list doesn't seem to save? 1
How to restrict zeros in a number from 16th digit onwards 5
"Bug" in number format for long number entries? 7
In Excel find 5 digit number and replace with leading zero 2
Replace numbers with time 3
Why does Excel replace any digits beyond 15 with zeros? 2

Top