|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.
Microsoft MVP - Excel
"G.Adamson" <gadams…@marshallswift.com> wrote in message
> 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
I enter in a 16 digit number and Excel turns the last digit to "O" posted by G.Adamson on Fri, 10 Oct 2003