Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to change the date format in a column from 2004/2/30 to
2/30/2004. There are 1,500 dates to change, in the column, and some are already in the correct format. Using the Date format for the column properties does not correct this problem. I tried to make a macro, which works, but it includes the original text, so can only be used once. Any suggestions on this are appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Swap . and , when importing to Excel 2007 | Excel Discussion (Misc queries) | |||
How to swap contents between 2 cells in MS Excel 2003? | Excel Discussion (Misc queries) | |||
Suggestion: Excel needs a swap option. | Excel Discussion (Misc queries) | |||
Text Strings Swap | Excel Worksheet Functions | |||
How can i swap between the tabs in excel? | Excel Worksheet Functions |