Hi,

Please try this.

First select the whole range or column then go to FORMAT and select CELLS.
Clik the Number Tab and select the TEXT option in CATEGORY and click OK.
Then Type the number in the cell.

If you are going to paste the values then copy it and paste it as UNICODE
TEXT or TEXT by way of doing the below mentioned procedure.

Before pasting the number go to EDIT and select PASTE SPECIAL and select the
UNICODE TEXT or TEXT and give ok.

I think it is ok for u.....

TGV

"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