Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I was keeping track of my credit card numbers with a spreadsheet. And when I enter a cc numer such as a visa card the last digit gets rounded to a "0" No matter what I tried this happened. But it doesn't happen in Excel 2003! I checked to be sure I was using a correct format (number entry in the cell and column I was in). I even tried chnaging the format to currency, etc, but nothing would work. The last digit no matter what I enter gets changed to a zero. This seems to happen beginning with the 16th number and actually continues if you enter more than 15 numbers (i.e. 16 numbers, 17 numbers, etc.) Try it ! Any ideas. Tx Chippo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need formula for dividing by "number of entries" in a column or row | Excel Discussion (Misc queries) | |||
"formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) | |||
find/replace "cr" from end of number to "-" in front of number | Excel Discussion (Misc queries) | |||
Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
Format a column wihtout using "Format-Cells-Number-category-etc" | Excel Worksheet Functions |