View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chippo chippo is offline
external usenet poster
 
Posts: 3
Default "Bug" in number format for long number entries?

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