Numbers

G

Guest

I'm trying to enter a 17 digit number on a cell and somehow it always changes
the last 2 numbers into a ceros. I have tried to format the cell to number
and general and it coutinues to do so. but only when I enter a large number
ei: 43343302223640001 then the one will auto change to cero.

help please. frustrated.
 
P

Peo Sjoblom

Excel has 15 numerical digit precision so you can either preformat the cell
as text or precede the entry with an apostrophe '
 

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

Large Number Question 3
cell format in Excel 2002 SP3 will not accept long numbers 1
numbers need to be numbers 4
In Format - General-How do I change it to an even number like 24 1
CONDITIONAL / NESTED COUNTIF 3
Counting Formula 3
What's wrong with this formula? 3
Default number format in Excel 1

Top