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

134 people found this reply helpful

Was this reply helpful?

Yes
No

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 August 15, 2021 Views 48,404 Applies to: