Month, Day, year format.
Select the column to date format (mm / dd / ) then use the macro
name is DayMonthYear
Code:
Sub DayMonthYear()
'Ðinh dang ngày tháng nam
'Day, Month, year format
Selection.NumberFormat = "mm/dd/"
End Sub
Select the column to the month, day, year (dd / mm / yy
Thanks for the help
On Thursday, August 30, 2012 6:57:37 PM UTC+1, RLM wrote:
>
> First post guys!
>
> I am trying to convert dates stored as text into proper formatted UK dates
> DD/MM/. A sample spreadsheet is attached. The dates as text are
> copied into a variant array, converted to a
Just append this line after pasting data in the range
Range("E2").Resize(UBound(RealDate), 1).NumberFormat = "dd/mm/"
Regards,
Lalit Mohan
On Thursday, 30 August 2012 23:27:37 UTC+5:30, RLM wrote:
>
> First post guys!
>
> I am trying to convert dates stored as text into proper formatted UK d
