Hi,

Can any one help me to join the following:-


Z column AA column AB column AC column
------------- ---------------- ----------------
----------------
Period: 1-Jun-07 to 29-Jun-07


I want to join the above 4 columns into A2 column like:

Period: 1-Jun-07 to 29-Jun-07

I used the below formula, but the date is appearing 39234 in numbers
and how to join 4 columns with correct date.

=Z1&", "&AA1

Pls help me in this regard

Thanks in Advance.

Shahzad
KSA