excel filter copy paste keep formatting

[rjmdc]

hi
my present copy paste filter peice of code blow copies and pastesperfectly. i have 2 rows of check numbers which when copied getthe little green triangle for text a numbers etc
how do i copy and paste keep formatting?

  'Auto Filter Filters
            wsViventium.Range("Z2") = Employees(e, 2)
            wsViventium.Range("AA2") = ">=" & startPeriod
            wsViventium.Range("AB2") = "<=" & endPeriod
        
            'AutoFilter to Report Sheet
            Range("VIVENTIUM_Folder_Paid[#All]").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=rngDest, CriteriaRange:=wsViventium.Range("Z1:AB2")

            'Resize Table
            lr = .Range("A1048576").End(xlUp).Row
            tbl.Resize .Range("A1:L" & lr)
            
            'Formatting
            .Columns.AutoFit
            
            'Export Reports with more than one row
            If tbl.ListRows.Count > 0 And tbl.ListColumns("id").DataBodyRange(1) <> "" Then