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 December 6, 2018 Views 45,169 Applies to:
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

123 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.