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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnePlus January 19 Credit Card Security Update: up to 40k customers may be affected 2
Credit Card Number in excel 2
Typing a credit card number in a cell 3
how to write 1234567890123456789 into a cell with number format 3
Large Number Error 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Problem with Values greater than a quardrillion(1,000,000,000,000, 1
Credit Card Number Formatting 8

Top