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. |
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