16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO

G

Guest

when typing a credit card number with 16 digits the last digit always returns
as a zero. Is there a way around this.
 
G

Guest

You will have to format it as text. Excel only supports 15 signifcant
figures. (Many computer programs have this limitation.)
Try formatting the cells as text before you type the numbers in.

tj
 
F

Frank Kabel

Hi
and another option would be to precede your entry with an apostrophe. e.g.
'1234567890123456
 

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

Top