When im adding 16 digit number last digit is automatically being 0. So what will be the solution for it ?

Question

When im adding 16 digit number last digit is automatically being 0. So what will be the solution for it ?

Answer 1

Either format the cell as Text before entering the value, or prefix the value with an apostrophe (aka single quote).

The value will be a text value, displayed exactly the way you enter it.

Answer 2

Dear respected Jay PatelPK,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, , you can also type an apostrophe (') before the number to force Excel to treat it as text. For example, type '1234567898794567 into the cell. This will prevent Excel from converting the number to scientific notation or changing any digits.

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Answer 3

Hi respected Jay PatelPK,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked above reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad