Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to create a macro that will format some dates on my
spreadsheet... Column 13 (M) has dates formatted as: Jan 23 2007 12:00AM - this is always the same length, so Jan 3 would be Jan 3 2007 12:00AM Column 19 (S) has dates formatted as: 2070109 (which is 1/9/07) Can someone please help me write a macro to format them as mm/dd/yy, w/o the time? I hate to post w/o providing some code but I don't really know where to start. Thank You, Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dates format | Excel Worksheet Functions | |||
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT | New Users to Excel | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
the dates on cell format make different dates. | New Users to Excel | |||
Macro changes the format of dates | Excel Programming |