| Home |
| Search |
| Today's Posts |
|
#1
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| How can I change Numbers in WOrds in Excel | Excel Discussion (Misc queries) | |||
| why have column letters changed to numbers in excel | Excel Discussion (Misc queries) | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Can I change the 15-digit limit in Excel for numbers ? | Excel Worksheet Functions | |||
Linear Mode
