Numbers turning to Zero's

G

Guest

Hello,
I am trying to place a large number (19 digits), into a cell, I do this, but
when I leave the cell the last four digits turn to zero's. Why?

Can anyone help, please.

When i go into format cell's the General shows the number in the following
format (*.*****E+13), this dosen't look right either, is it?
 

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

Zero's plotted in charts? 1
Zero's # 2 3
last digits change to zero 2
Insert leading zero's 2
Loosing Zero's in front of number 4
How do I stop Excel from dropping leading zeros? 9
Converting numbers formatted as text to numbers 1
keeping leading 0's when formatting cells 3

Top