last digits change to zero

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
 
M

MH

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?
 
G

Guest

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

Numbers turning to Zero's 1
Convert Last 3 digits to zero 2
How to get thousand seperator after every two digits 2
0987 show in the cell - the zero drops off-ned all 4 digits 2
Last 4 digits of SSN 10
turn off scientific notation? 3
how to display zero prefixes in worksheet cells such as phone numb 1
Format cells to always have 13 digits? 2

Top