Last digit being changed when pasting large numbers.

  • Thread starter Thread starter drosdin
  • Start date Start date
D

drosdin

When I paste a large number into excel (example:
8211560020263357) it changes the last digit to 0. Well,
first it displays at 8.21E+15, but when I change the
formating to number I can get it to display as a full 16
digit number, but the last digit is always changed to 0.
Is this a known bug or is there a workaround?

I have tried formatting the cells to number with no
decimal places. I've tried word wrap. Is there a setting
I need to change?

Thanks.
 
If Excel interprets it as a number, the maximum is 15 digits, imposed by the IEEE format for
double precision floating point numbers.

You need to format the cell as text before you paste.
 
I didn't mention that because he said "When I *paste*...". No way to include the apostrophe when
pasting, is there?
 
If it's a single number (as in the OP's example), sure - type ' to
enter edit mode, then CTRL-v to paste the number. Hit Enter.
 
Back
Top