Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing a credit card number in a cell
Every time I try to put in the last number of my 16 digit credit card number
Excel makes it a zero. I have tried formatting in number and text. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing a credit card number in a cell
Yes, XL, like most spreadsheets, has a 15-decimal digit precision.
But since you're almost certainly not doing math on the credit card number, either preformat the cell as Text (so XL won't interpret the entry as a number), or prefix the entry with an apostrophe: '0123456789012345 In article , Jimbo wrote: Every time I try to put in the last number of my 16 digit credit card number Excel makes it a zero. I have tried formatting in number and text. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing a credit card number in a cell
Excel handles only 15 digits until it loses values due to rounding. If
you have a longer number, you can either format the cell as Text (Format menu, Cells item, Number tab, choose Text) before entering the data or precede the value with an apostrophe. The apostrophe will not be displayed in the cell, but will be visible in the formula bar. Both of these methods assume that you will not due calculations on the number (as is the case with data such as credit card numbers) although sorting and filtering will still work. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 17 Jan 2009 06:23:01 -0800, Jimbo wrote: Every time I try to put in the last number of my 16 digit credit card number Excel makes it a zero. I have tried formatting in number and text. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Typing a credit card number in a cell
Chip wrote on Sat, 17 Jan 2009 09:05:45 -0600:
Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 17 Jan 2009 06:23:01 -0800, Jimbo wrote: Every time I try to put in the last number of my 16 digit credit card number Excel makes it a zero. I have tried formatting in number and text. A minor warning based on my own sad experience. Be consistent with the card number format if you are going to sort. You will get different results from using a 16-digit number and groups of 4 separated by blanks or "-" signs. -- James Silverton Potomac, Maryland Email, with obvious alterations: not.jim.silverton.at.verizon.not |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i show only the last four digits of a credit card number | Excel Discussion (Misc queries) | |||
Credit Card Number | Excel Worksheet Functions | |||
Credit Card Number | Excel Worksheet Functions | |||
Custom format for credit card number | Excel Discussion (Misc queries) | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |