Try pre-format the cell(s) or the entire col as text
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vijay Kotian" wrote:
I have encountered an unique problem, wherein, while opening a file where
more than 16 digits are there, excel automatically converts digits to 0 after
16th digits. Can anyone help me out to resolve this issue.

e.g. if my number is 20071022123456789 it is automatically converts to
20071022123456700, last two digits 89 is automatically takes it as 00.

How is it possible to take full number ........ 20071022123456789 ?

Thank you.