ExcelBanter - last digit automatically changes to zero (0)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - last digit automatically changes to zero (0) (https://www.excelbanter.com/excel-worksheet-functions/122972-last-digit-automatically-changes-zero-0-a.html)

[email protected]

last digit automatically changes to zero (0)

i'm entering a 16-digit credit card account number into a cell, and
after hitting "enter" the last digit automatically changes to a zero...
plse help!!

Gary''s Student

last digit automatically changes to zero (0)

Fomat the cell as text before entering the value

or

precede the entered value with an apotrophe (single quote).
--
Gary's Student

" wrote:

i'm entering a 16-digit credit card account number into a cell, and
after hitting "enter" the last digit automatically changes to a zero...
plse help!!

All times are GMT +1. The time now is 11:17 PM.