Enter credit card number in a cell

V

Varun.M

when ever i enter a credit card number that is 16 digits(or any other number
more that 16 digits), the last numbers in series automatically turn into
zeros.

Kindly help me in displayed the actual data as entered by me.
 
S

Stefi

The cell is formatted like General or Number. Format it like Text before
entering card number (it's really not a number but a string of digits).

Regards,
Stefi

„Varun.M†ezt írta:
 
S

ShaneDevenshire

Hi,

You can also start the entry with an ' (apostorphe) - this tells Excel the
entry is text.
 
Top