Keep large numbers from truncating?????

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
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
Click to expand...

Format the cell as TEXT before entering the CC number.


--ron
 
Back
Top