Hi,

The number you posted is 16 digits not 12 and after 15 digits Excel can't cope

Use text

2 Options:
- format the cell as Text before entering the number
- precede the entry with an apostrophe. It will not show in the cell

See the "IEEE Floating Point Standard" section on
http://www.cpearson.com/excel/rounding.htm for the technical reasons for
that particular limit.

Mike



"Prem Soni" wrote:

Hi All,

When i have inserting 12 digit character (5176521004331981) in MS Excel 2003
it converting to 5176521004331980 automatically.

can anyone help me on this why this is happening even after formatting cell
by number category?

Thanks in Advance,
PREM SONI