Thread
:
"Bug" in number format for long number entries?
View Single Post
#
2
Posted to microsoft.public.excel.misc
paul[_2_]
external usenet poster
Posts: 31
"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
Reply With Quote
paul[_2_]
View Public Profile
Find all posts by paul[_2_]