![]() You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. Select the cell or range of cells that you want to format.Ĭlick the cell, or press the arrow keys to move to the cell.Ĭlick the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection. To successfully display a 16-digit credit card number in full, you must format the number as text.įor security purposes, you can obscure all except the last few digits of a credit card number by using a formula that includes the CONCATENATE, RIGHT, and REPT functions. ![]() ![]() In addition, Excel displays the number in exponential notation, replacing part of the number with E+n, where E (which signifies exponent) multiplies the preceding number by 10 to the nth power. If you create a custom number format for a 16-digit credit card number (such as # or #-#-#-#), Excel changes the last digit to a zero because Excel changes any digits past the fifteenth place to zeros.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |