why is my last digit converted to zero?

[Guest]

I'm using Excel 2003 and when I enter a 16-digit number or cut and paste a
16-digit number, the last digit is converted to zero. This does not happen
with 15 digits or fewer.

 

[Niek Otten]

Excel's numeric precision is 15 decimal digits.
If you need to calculate with the number, you probably won't miss anything.
If the number is a key, such as a creditcard number, add an apostroph
(single quote, " `") before it; it will not show, but it will cause the
number to be treated as text.
Another way is to format the cell as text before entering the number

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Frank Kabel]

Hi
Excêl only supports 16 signifanct digits. So in your case enter the
number as 'Text':
- either precede the entry with an apostrophe: '0123456789012345
- or preformat the cell as 'Text'