I cannot enter a number containing more than 15 digits in Excel

[Sourav]

I cannot enter a number containing more than 15 digits in Excel. Specialy
whwn the no is like 1668001700025402. after entry it displays like
1668001700025400 (even after changing the cell format into Number)
Pls give me response.

 

[Ms-Exl-Learner]

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok. Now enter the numbers in the
formatted cells.

Otherwise before entering the value in a cell type ' and enter your numbers.

But both the options will treat the number values as text.

Remember to Click Yes, if this post helps!