Hi

Not sure if i understood correctly, but i would first of all changed the format of cells (where the values are imported) to text - this will prevent excel from autoamtically changing the format. If the value is without leading zeroes, you can simply use &, like ="0" & a1, where a1 is the number without leading zeros.

Or is your question about how to actually append those numbers one after another?

Bartek