Format dates from specific column

[kbenjamin827]

Hi all,

I am working with pivot tables, and the imported data always comes in as dd.mm.yyyy is there a way to create a macro that formats specific columns from dd.mm.yyyy to mm/dd/yyyy?f

 

[WaterGypsy]

Can't you just set the format of the data in the pivot table itself?

 

[kbenjamin827]

I believe the changes need to be made at the source. I know what youre referring to but it is not working

 

[WaterGypsy]

you could try something like this - it depends on where your data is

Dim sSplit

    sSplit = split(Range("a1"), ".")
    
    Range("b1").Value = DateSerial(sSplit(2), sSplit(1), sSplit(0))