View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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