Last digit automatically changes to zero (0)

M

mghops

I created a spreadsheet for my personal budget. When I type a 16-digit
credit card number into a cell and then hit "enter", the last digit of
my number automatically changes to a zero. Advice??
 
M

Martin Fishlock

Numbers have a precision of 15 significant digits.

As it is a credit card number store it as text.

That is Format|Cell and set it to text.
 
J

Joerg

Your question was already answered in excel.worksheet.functions group
Please don't crosspost!

Joerg
 

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

last digit automatically changes to zero (0) 1
Macroto delete extra space in a cell 3
excel help 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
VBA Code for converting Type-E UPC to Type-A (barcodes) 1
corrupt file plus 8 digit temp 0
Typing a credit card number in a cell 3

Top