|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 7th, 2005, 08:50 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
why does excel change last digit of credit card numbers to zero?
Using Excel 2002, cutting and pasting credit card numbers, but excel changes
the last number on many of them to zero. If I hold the mouse over the cell, it shows the right number. 
|
|
#2
December 7th, 2005, 09:05 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
why does excel change last digit of credit card numbers to zero?
Format as text, excel has only 15 digits precision
-- Regards, Peo Sjoblom "dacton" wrote in message ... Using Excel 2002, cutting and pasting credit card numbers, but excel changes the last number on many of them to zero. If I hold the mouse over the cell, it shows the right number.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Version 8 Integration for SOP does not pick up the credit card specified in the source field it uses the default credit card against the debtor. | Jen | General Discussion | 1 | September 14th, 2005 03:17 AM |
| how do i hid credit card numbers in access | mrdkr | Setting Up & Running Reports | 2 | September 11th, 2005 03:09 PM |
| How can I change positive numbers to negative, i.e. change 50 to - | godwingi | General Discussion | 5 | February 28th, 2005 05:41 PM |
| Excel 2003 Problem - Numbers that don't work like numbers ! | Ken Frost | General Discussion | 11 | October 4th, 2004 07:38 PM |
| Credit Card Character Count | AL V | Running & Setting Up Queries | 1 | June 30th, 2004 06:48 PM |
Linear Mode
