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?
 

Question Info


Last updated February 5, 2020 Views 47,427 Applies to:
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
www.eileenslounge.com

131 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.