Preserve date format while copying from one excel to another

[Tejas Kore]

Hi Friends,


I have this data in one column.


Date
29-12-2017
30-12-2017
When I am pasting this data in another excel through VBA code , it is not preserving data format.
This is the sane data after pasting.


Date
43098
43099


I guess these are no. of days.
Do we have a way in which we can preserve the date format ?

This is my code snippet of pasting data

wsO.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

 

[Nine Zero]

Change where you have

xlPasteValues

to

xlPasteValuesAndNumberFormats

try that

 

[Tejas Kore]

Thanks a lot Nine Zero !!.

It works perfectly fine .

 

[Nine Zero]

no problem

 

[Tejas Kore]

Yeah .... Happy New Year in advance