How do do Concatenated Cell Values

[Kevin M]

Steve,
use this.

A6=A1&A2&A3&A4&A5

and format A1-A5 as 'custom' with 00 as the custom format.
HTH
Kevin M

-----Original Message-----
I have 5 cells that contain code values. Everytime one

of the cells changes values I want to concatenate the
cell values together into another cell. For example:

Cell A1's value is 1
Cell A2's value is 12
Cell A3 doesn't have a value.
Cell A4's value is 3
Cell A5 doesn't have a value.
Cell A6 concatenateve value would be 011203.

1. If the user went in and changed the Cell A1 value to

be 20, the new concatenated value in A6 would be 201203.

2. If the user went in and deleted the Cell A1 value,

the new concatenated value in A6 should be 1203.

3. If the user went in and changed the Cell A5 value to

be 15, the new concatenated value in A6 would be 01120315.

In otherwords, the formula in Cell A6 should be

triggered to reconcatenate the values in A6 whenever any
value is changed in Cells A1-A5. A6 would be a blank
value if all values in A1-A5 are cleared out or deleted.
Also note that I would like to have a leading zero
entered for any cell values less than 10.