Macro for pasting data in DD/MMM/YYYY format

[Chandresh]

HI All,

I am using below code for copying and pasting the dates in another workbook macro is working fine however the date format changes.

Could you please help me with the macro which can copy and paste the data in DD/MMM/YYYY format.


Workbooks("ITRM.xlsm").Worksheets("05-Advance Tax Paid").Range("B3:B402").Copy

Workbooks("ITR.xlsm").Worksheets("IT").Range("E18").PasteSpecial Paste:=xlPasteValues

Thanks
Chan

 

[VBE313]

Is there data that you are copying already in that format?

 

[Chandresh]

yes the data is in the same format- DD/MMM/YYYY