Excel keeps track of 15 significant digits.

If you need more, you can treat the value as text by:
1. Precede the entry with an apostrophe: '1234123412341234
2. Pre-format the range as Text, then do the data entry.


Vinod wrote:

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

--

Dave Peterson