Character limit

[Gaurav675]

Hi,

When I write 16 number in excel, it changes the last two number to zero. Please help me.

Example I write 67221190730010905 excel shows 67221190730010900

[#2 · Accepted solution]

@Gaurav675 

Excel displays numbers with only 15 digits of precision. See Excel specifications and limits 

If you want to store the value as text, either format the cell as text before entering the value, or prefix it with an apostrophe: '67221190730010905