| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncating numbers to show last three digits | Excel Discussion (Misc queries) | |||
| Truncating whole numbers - diplaying thousands instead of full num | Excel Discussion (Misc queries) | |||
| numbers truncating | Excel Discussion (Misc queries) | |||
| Truncating numbers | Excel Worksheet Functions | |||
| large numbers going from XLS to CSV | Excel Discussion (Misc queries) | |||
Linear Mode
