How to concatenate with original date format

[ThrottleWorks]

Hi,

I have values such as 15/03/2017 00:00:00 in a column.
I am trying concatenate it with ‘=C2&D2&F2’ formula, in coding, formula is reflecting as ‘Range("A2:A" & TempLr).FormulaR1C1 = "=RC[2]&RC[3]&RC[5]"’.

However value of concatenate result is reflecting as ‘08860316-0-EUR-CASH428094.29’.
Can we reflect the value of formula result as 08860316-0-EUR-CASH15/03/2017 00:00:004.29

Date value is in cell D2, with format as ‘m/d/yyyy hh:mm:ss’.

Can anyone please help me in this.

PS - Bold is marked for Forum purpose only. Not requirement.

 

[Marc L]

Hi !

As a real date is a number, the same way as yet shown in your old thread
using same format with TEXT worksheet function !
​

 

[ThrottleWorks]

Hi @Marc L sir, thanks a lot for the help.

Have a nice day ahead.