Precede the number with a single quote
OR
Pre-format the cells as text
You will not be able to do arithmetic on these values but I doubt they are
real numbers.
Excel has a 15 digit precision limit.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address
"Vinod" wrote in message
...
How to restrict zeros in a number from 16th digit onwards.
In other wards I made cell format as "Number" with no decimals. I entered
a
number in that particular cell with 1234567891234567 (16 digit number)
after
enter key it converting as 1234567891234560 ( "0" at 16 digit)
Advanced Thanks,
Regards,
Vinod