S
Static
Okay I have a collumn of formulas that generate numerical codes.
Because they're codes I need them to retain the 000 padding before them.
I do this by using the custom padding. so excel displays the collumn like...
0000001
0000002
0000003
Now... I need to concatenate these numerical values to the end of a text
code.
so I'm adding say, "code" to the begining of each.
what I want looks like
code.0000001
code.0000002
code.0000003
but when I try to do it, I loose the padding, resulting in
code.1
code.2
code.3
any ideas?
Because they're codes I need them to retain the 000 padding before them.
I do this by using the custom padding. so excel displays the collumn like...
0000001
0000002
0000003
Now... I need to concatenate these numerical values to the end of a text
code.
so I'm adding say, "code" to the begining of each.
what I want looks like
code.0000001
code.0000002
code.0000003
but when I try to do it, I loose the padding, resulting in
code.1
code.2
code.3
any ideas?