12 Digit converting in excel 2003

[Prem Soni]

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

 

[David Biddulph]

I think you are struggling to count. You started with 16 digits, not 12.
Excel has a precision of 15 significant digits for numbers, so if you want
to show the 16 characters as a text string you'll need to format the cell as
text before you type in the 'number', or precede it by an apostrophe.

 

[Mike H]

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]

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

PREM SONI

 

[TGV]

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]

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