Hello everyone...
I have a cell (date) that I need to copy to another sheet and use delimiters to separate.
For example: 2024/11/8
if I use delimiter manually, the result is 2024 11 8 which is what I want to achieve.
but when I run VBA it become 11 8 2024
Is there any command that I need to add to achieve the result I want?
Thank you in advance.
I have a cell (date) that I need to copy to another sheet and use delimiters to separate.
For example: 2024/11/8
if I use delimiter manually, the result is 2024 11 8 which is what I want to achieve.
but when I run VBA it become 11 8 2024
Is there any command that I need to add to achieve the result I want?
VBA Code:
Columns("E:E").Select
Application.CutCopyMode = False
Selection.NumberFormatLocal = "yyyy/m/d"
Selection.TextToColumns Destination:=Range("E1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:="/", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), _
TrailingMinusNumbers:=True
Thank you in advance.