Excel is changing the last digit to 0

G

Guest

I am trying to enter some numbers into an excel spreadsheet and the program
keeps changing my last digit to 0. These are 16 digit numbers. Is there any
way to fix this? What is going on?
 
G

Guest

Thanks Chip!!!

Chip Pearson said:
Excel is limited to 15-digit precision. To enter longer numbers,
precede the number with an apostrophe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


message
Click to expand...
 

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

Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Excel Changes My Last Digit to Zero 1
How do I keep a 17 digit number from ending in "0" in excel? 6
last digit in string gets changed to 0 (16 characters long) 3
16 digit number entry changes last digit to 0 1
16 digit numbers 2
Last digit of long numbers changes to 0 2
Entering a 16 digit number 1

Top