Excel is changing the last digit to 0

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