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
Bookmarks