I have a list of numbers like this:
<TABLE style="WIDTH: 91pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=121 border=0><COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 91pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right width=121 height=20>1708388021</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>17080880000</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>1.70832E+12</TD></TR></TBODY></TABLE>
I want to format them where they will all be in the same format:
17-083-88021-0000 (this one needed to have 4 zeros added at the end)
17-080-88000-0000 (this one needed only 3 zeros added)
17-083-20981-0000 (this one only needed 1 zero added)
And if I have one like 17083123451234 then it would automatically know that it had enough digits and to just add the dashes 17-083-12345-1234
Any idea how i can do this? Thanks a bunch.
<TABLE style="WIDTH: 91pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=121 border=0><COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 91pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right width=121 height=20>1708388021</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>17080880000</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right height=20>1.70832E+12</TD></TR></TBODY></TABLE>
I want to format them where they will all be in the same format:
17-083-88021-0000 (this one needed to have 4 zeros added at the end)
17-080-88000-0000 (this one needed only 3 zeros added)
17-083-20981-0000 (this one only needed 1 zero added)
And if I have one like 17083123451234 then it would automatically know that it had enough digits and to just add the dashes 17-083-12345-1234
Any idea how i can do this? Thanks a bunch.