Excell Glitch???

[Guest]

Excell 2002 version is changing the last number of my credit card accounts to
0!!
Can I be doing something wrong?

I am using Excell 2002. I created a list of my credit cards to keep track of
them, and I just have noticed that in a column that I named credit card
numbers, the last digit is changed to "0" !!!

I customized to accept 16 numbers (####-####-####-####) which follow the
credit card format account numbering. when I enter the numbers say
1111222233334444 I expected to get 1111-2222-3333-4444; however to my
surprise I am getting 1111-2222-3333-4440, and it does not matter that I try
to change it. I will still get the same result. I tried changing the whole
column cell format to just Text or to Number, but I does not help.

Is this a major flow in Microsoft Excell (2002) or am I missing somthing?
I will appreciate any suggestions, Thanks

 

[RWN]

The numeric format in xl will only handle 15 digits.
One method is to put an apostrophe in front of the values to convert them to
text.

 

[David McRitchie]

Hi Gabriel,
You cannot customize Excel to 16 digits because Excel can
only have 15 significant digits. Suggest you use text for ids
and leave number for numbers that are to be treated arithmetically.

The space a number occupies has nothing to do with how you format the
display.

Format the column as text and reenter the digits. As an alternative
you can precede the number with a single quote, but is a lot better and
safer to format the entire column as text.
-

 

[JE McGimpsey]

Another is to preformat the entry cell as Text.

 

[Don Guillett]

You need to format as text. And, PLEASE do NOT multipost. Considered bad
netiquette here.