Combine a text with a date

[tranamal]

If I have a date in cell A1 (FEB-08)[February 2008] and combine that with a text "LY" and put it into cell A2 to show "LY FEB-08".

I tried using =CONCATENATE("LY ",A1) or using ="LY "&A1
both give the same result but not what I wanted. It shows LY 39479 (the date turns into numerical value and not a date).

Help,
Tranamal

[DonkeyOte]

Dates are integers, 39479 being the integer value of your date... you can use TEXT function

A2: ="LY "&TEXT(A1,"MMM-YY")

(or you could think of just using a Custom Format: set A2 = A1 ... Custom Format of: "LY" MMM-YY)