Forum Discussion
Solved
Character limit
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
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
1 Reply
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