Date not showing after paste

[konficus]

I have a report file, in some section i am copying a table from a remote computer into local excel file, but after copy date's are not like date, i need to search & replace everytime ( search "." replace with "." )then dates comes. I have a vba code but not correcting in all sheets.

Sub tarihecevir()    Dim sht As Worksheet
    Dim fnd As Variant
    Dim rplc As Variant

    fnd = "."
    rplc = "."

    For Each sht In ActiveWorkbook.Worksheets
        sht.Cells.Replace what:=fnd, Replacement:=rplc, _
                          LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
                          SearchFormat:=False, ReplaceFormat:=False
    Next sht End Sub

It works with normal ctrl+H but macro doesnt fix it. Please help me.

 

[konficus]

any help?

 

[xenou]

I'm not familiar with periods ( "." ) in dates. What format are you dates actually in here? Can you use a standard date format instead ( such as 01/01/2018 )?

 

[konficus]

I'm not familiar with periods ( "." ) in dates. What format are you dates actually in here? Can you use a standard date format instead ( such as 01/01/2018 )?

In our country date format is like 01.01.2018 and the file i get also 01.01.2018 but after copy/paste it shows 01.01.2018 but excel formulas doesnt recognize as date, and i am doing find&replace. after that formulas sees it.

 

[xenou]

I suppose you should make sure that your cells here aren't formatted as Text. That could also cause this problem.
I can't test - don't use that date format here.