Numbering

J

John

I have a listing of 16 digit numbers in Microsoft Word. (################)
that i need to put into Excel. When i copy it and paste into Excel it
converts the last number to a zero. Is there a way to make this not happen?
I have probably 300 cards to copy and paste
 
J

JE McGimpsey

XL has a limit of 15 digits of precision. If these "cards" are, say,
credit card numbers, format the cells as Text before pasting.
 
J

JE McGimpsey

The scientific notation is just because the parser's interpreting it as
a number.

It works for me when I paste special as Text.
 
R

RagDyer

Guaranteed that you *didn't* follow John's instructions to format the cells
as TEXT ... *BEFORE* pasting!
 
Top