ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   why does excel change last digit of credit card numbers to zero? (https://www.excelbanter.com/new-users-excel/59311-why-does-excel-change-last-digit-credit-card-numbers-zero.html)

dacton

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.

Peo Sjoblom

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.





All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com