Hi there

I have a spreadsheet with 6 columns;

The data in the columns for example are:

100 01 02 022 10 A3

I need to concatenate them, but when I do I lose the first '0' in the column and get the following result:

100122210A3

I need the result as: 100010202210A3

What do I need to change to get the zero back?

Thanks
Lynn