View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
paul[_2_] paul[_2_] is offline
external usenet poster
 
Posts: 31
Default "Bug" in number format for long number entries?

15 is the limit for excel to display properly AFAIK...format as text and you
will be right
--
paul

remove nospam for email addy!



"chippo" wrote:

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