Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date formatting in excel VBA
I'm trying to convert a text date - time to internal date format, I can do
this fine by copying the column and past special with add to another column and pasting back to the first column. Ive used record macro to create VBA code to do the same, but get american date format 12/07/05 06:02 becomes 7/12/05 and 13/12/05 06:05 returns null. The VBA code created by the macro recorder is as follows :- Sub DateFormatter() ' ' DateFormatter Macro ' Macro recorded 12/7/2005 by Johnsd ' ' Columns("G:G").Select Selection.Copy ActiveWindow.SmallScroll ToRight:=2 Columns("N:N").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Selection.Cut ActiveWindow.SmallScroll ToRight:=-7 Columns("G:G").Select ActiveSheet.Paste Selection.NumberFormat = "d/m/yyyy h:mm" End Sub -- Can anyone help Thanks in advance DaveJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting date in Excel | Setting up and Configuration of Excel | |||
Excel date formatting | Excel Discussion (Misc queries) | |||
Date formatting in Excel | Excel Discussion (Misc queries) | |||
date formatting in excel | Excel Worksheet Functions | |||
Date formatting in Excel | Excel Discussion (Misc queries) |