How to format date in vba

[ThrottleWorks]

Cell A1 value is today’s date in dd mmm yyyy format (08 Jan 2013)

Cell A2 value is Data_

I want to concatenate in following manner


Data_08 Jan 2013


But excel is giving me Data_41282

I am using following formula to concat, =a2&a1


Can anyone help me in this please

 

[Luke M]

Since you're converting a numerical value (date) into text, need to use the TEXT function like this:

=A2*TEXT(A2,"dd mmm yyyy")

 

[ThrottleWorks]

Sir thanks a lot for the help but this is giving me different result.


1704203524


=M3*TEXT(M3,"dd mmm yyyy")


I have populated date using today formula in cell m3 to recheck the results.


Kindly help.

 

[Luke M]

Oops, my apologies. It should be an ampersand, not asterisk, and the function should reference A1, not A2. Man...need to get some coffee I guess. <embarassed>

=A2&TEXT(A1,"dd mmm yyyy")

 

[ThrottleWorks]

Sir you are great, thanks a lot. Have a nice day ahead.