Keep large numbers from truncating?????
 

We copy/paste credit cards numbers into Excel, but the
numbers that have 16 digits get truncated to a "0" in the
last digit. Excel has a 16 digit limit. Is there any way
to overcome this?

TIA
Paul

Keep large numbers from truncating?????
 

On Thu, 30 Oct 2003 09:55:09 -0800, "Paul" wrote:

We copy/paste credit cards numbers into Excel, but the
numbers that have 16 digits get truncated to a "0" in the
last digit. Excel has a 16 digit limit. Is there any way
to overcome this?

TIA
Paul

Format the cell as TEXT before entering the CC number.


--ron

Keep large numbers from truncating?????
 

Ron Rosenfeld wrote:

On Thu, 30 Oct 2003 09:55:09 -0800, "Paul" wrote:


We copy/paste credit cards numbers into Excel, but the
numbers that have 16 digits get truncated to a "0" in the
last digit. Excel has a 16 digit limit. Is there any way
to overcome this?

Format the cell as TEXT before entering the CC number.


Or prefix with a single quote.

Jerry

Keep large numbers from truncating?????
 

On Thu, 30 Oct 2003 23:10:33 GMT, "Jerry W. Lewis"
wrote:

Ron Rosenfeld wrote:

On Thu, 30 Oct 2003 09:55:09 -0800, "Paul" wrote:


We copy/paste credit cards numbers into Excel, but the
numbers that have 16 digits get truncated to a "0" in the
last digit. Excel has a 16 digit limit. Is there any way
to overcome this?

Format the cell as TEXT before entering the CC number.


Or prefix with a single quote.


I didn't know how to do that with a copy/paste operation.


--ron