Re: I enter in a 16 digit number and Excel turns the last digit to "O"

Giganews Newsgroups
Subject: Re: I enter in a 16 digit number and Excel turns the last digit to "O"
Posted by:  Chip Pearson (ch…@cpearson.com)
Date: Fri, 10 Oct 2003

Format the cell for Text prior to entering the value, or include an
apostrophe (') at the beginning of the number.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com    ch…@cpearson.com

"G.Adamson" <gadams…@marshallswift.com> wrote in message
news:01ff01c38f60$e235e0c0$a40128…@phx.gbl...
> Hello,
> I have credit card numbers that I have entered into and
> Excel spreadsheet (ex.  4444444444444444).  When I entere
> this in excel changes the last digit to "0" (ex.
> 4444444444444440).  I am thinking that some sort
> of "Masking" is going on?  How can I convert this back to
> the original true cc #?
>
> Thank you,
> G. Adamson

Replies

In response to

I enter in a 16 digit number and Excel turns the last digit to "O" posted by G.Adamson on Fri, 10 Oct 2003