If the value in A1 is actually a date, then use this.........

=TEXT(DATE(B1,MONTH(A1),DAY(A1)),"dd-mmmyy")

Vaya con Dios,
Chuck, CABGx3




"orquidea" wrote:

Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea