E
E
Eugene M2019-10-28 18:38:04
excel
Eugene M, 2019-10-28 18:38:04

How to insert card number in excel?

I have a problem, I can’t insert a bank card number into an excel, I insert the number, but for some reason the last number changes, the cell format settings are "General Format". It should be the last numbers 75 and for some reason makes 70.
5db70b20cc402834675784.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2019-10-28
@ProgrammerForever

If stored as a number, you cannot get more than 10 to the power of 15.
Need to store as text and apply template to cell format
0000" "0000" "0000" "0000

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question