Padding and Concatenate

[Guest]

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?

 

[Guest]

If the numbers are in column A, consider:

="code."&Text(A1,"0000000")

 

[Guest]

ah yes, thank you. Thats exactly what I needed.