Last digit automatically changes to zero (0)
 

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??

Last digit automatically changes to zero (0)
 

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.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


" wrote:

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??

Last digit automatically changes to zero (0)
 

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

Joerg
wrote in message
oups.com...
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??