| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically convert Text with 2-digit year | Excel Discussion (Misc queries) | |||
| How do I limit a cell to one digit and have it automatically tab? | Excel Discussion (Misc queries) | |||
| last digit automatically changes to zero (0) | Excel Worksheet Functions | |||
| last digit automatically changes to zero (0) | Excel Worksheet Functions | |||
| entering 16 digit number in Excel suffix 0 comes automatically | Excel Discussion (Misc queries) | |||
Hybrid Mode
