last digits change to zero

  • Thread starter Thread starter djgosling
  • Start date Start date
D

djgosling

Hello,
I am trying to enter a long number (19 digits), enter the number, but
when I leave the cell, the last 4 digits change to zero's. How can I
overcome this.

When I go into format cell's and general, the number I have entered
shows up as a scientific number (*.*****E+13), is this normaL or
adnormal?

Please help, if you can, thanks.

Dave Gosling
 
It's normal, Excel works with fifteen significant figures so any digits
after the fifteen most significant ones will be zeros. Do you need all
nineteen digits to be displayed?
 
Hi

That is the way it is! If you want more digits to be displayed either format
the cell as text before you enter the data or precede your entry with an
apostrophe ' eg '1234567891234567

Andy.
 

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

Number starting with zero 5
Actual solution 2
Entering 18 digit number in Excel 9
Adding recognised Zeros 5
Custom format leading zero 5
format of number keeps changing 2
Displaying zeros in cells 2
Excel Changes My Last Digit to Zero 1

Back
Top