When I am entering 16 digit number in excel, its automatically round off? Whats the solution?

When I am entering 16 digit number in excel, its automatically round off? Whats the solution?
Answer
Answer

Excel stores numbers with a maximum precision of 15 significant digits. It cannot handle 16 digit numbers.

If the value is some kind of ID number, you probably don't have to perform calculations with it. If so, you can format the cell as text before entering the value, or prefix the value with an apostrophe ' to force it to be interpreted as text.

If you need to perform calculations with numbers of 16 or more digits, you'd need to install an add-in that provides this capability.

---
Kind regards, HansV
https://www.eileenslounge.com

132 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 27, 2021 Views 48,187 Applies to: