Enter credit card number in a cell

  • Thread starter Thread starter Varun.M
  • Start date Start date
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.
 
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:
 
Hi,

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