Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Help with formula 4
CONDITIONAL / NESTED COUNTIF 3
How I change the format 0 to - 2
data truncates when converting .csv to .xls 5
Keeping a cell value constant trhoughout a list of values 2
Large Number Question 3
Default number format in Excel 1
Mail Merge with Word 2

Back
Top