ChrisFoster
Board Regular
- Joined
- Jun 21, 2019
- Messages
- 246
- Office Version
- 365
- Platform
- Windows
Hi all,
I am using the below code to remove the time stamp on a column of dates (I just want the date not the time as well).
But it formats in to US Date format and not UK, even though the original format is UK. It's driving me mad.
Does anyone know how to do this but keep the date in UK format?
I am using the below code to remove the time stamp on a column of dates (I just want the date not the time as well).
But it formats in to US Date format and not UK, even though the original format is UK. It's driving me mad.
Does anyone know how to do this but keep the date in UK format?
VBA Code:
Columns("G:G").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Columns("F:F").Select
Selection.TextToColumns Destination:=Range("F1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 4), Array(10, 1)), TrailingMinusNumbers:=True
Last edited by a moderator: