You will need to store them as Text, because Excel will only never show more than 15 significant digits for numbers. Then you can use a formula:I have thousands of lines of unique 16 digit numbers.
A | B | C | |
1 | Input | Output | |
2 | 1980039667511667 | 00001980039667511667 | B2: =RIGHT(REPT(0, 20) & A2, 20) |
3 | 160024896898520 | 00000160024896898520 | |
4 | 15737642057 | 00000000015737642057 | |
5 | 37108985297597 | 00000037108985297597 | |
6 | 8620660 | 00000000000008620660 |
This formula in cell B2 will also work...You will need to store them as Text, because Excel will only never show more than 15 significant digits for numbers. Then you can use a formula:
A B C 1 Input Output 21980039667511667 00001980039667511667 B2: =RIGHT(REPT(0, 20) & A2, 20) 3160024896898520 00000160024896898520 415737642057 00000000015737642057 537108985297597 00000037108985297597 68620660 00000000000008620660
<tbody>
</tbody>
Hmm, you are right (of course)... bad testing on my part.I don't think so:
A B C 201234567890123456 00001234567890123450 B2: =TEXT(A2,REPT(0,20))