When you get a date from BEx Analyzer or Analysis Office the Excel internal format
is Text and not Date. This means that the sorting doesn’t work correctly. Use the following VBA source code to convert easily text to date.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
Sub Text_to_Date() Dim dDate As Date Dim dRange As Range Set dRange = Range(Selection.Address) For Each Cell In dRange If IsDate(Cell.Value) Then dDate = Cell.Value Cell.Value = dDate End If Next End Sub |
These posts might also be intersting:
author.
I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
Schreibe einen Kommentar