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

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

Hi Thanks for reply and soory for writing 12 digit instead of 16.

PREM SONI

"Mike H" wrote:

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

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

Hi TGV,

I have already found the solutions myself. I was just wanted to know why its
happened in excel and now i also got it know.

Thanks
PS

"TGV" wrote:

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