| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change date
I have a rather large list of dates that are in a column and are written
first as year then month then day Ex: 20051116. I want to change all of them in a date format like this 11/16/2005 with out retyping each one. I have tried to change the format but excel will not read it. I have tried to make a macro but excel only changed that one cell not the entire column. Please help. |
|
#2
|
|||
|
|||
|
On Fri, 22 Apr 2005 17:29:30 -0700, "Quandary"
wrote: I have a rather large list of dates that are in a column and are written first as year then month then day Ex: 20051116. I want to change all of them in a date format like this 11/16/2005 with out retyping each one. I have tried to change the format but excel will not read it. I have tried to make a macro but excel only changed that one cell not the entire column. Please help. Select your column of dates. Then: Data/Text to Columns Next Next Column Data Format Date:YMD Finish --ron |
|
#3
|
|||
|
|||
|
Select the column of dates.
DataText to ColumnsNextNext. Format data typeDateYMD and Finish. Gord Dibben Excel MVP On Fri, 22 Apr 2005 17:29:30 -0700, "Quandary" wrote: I have a rather large list of dates that are in a column and are written first as year then month then day Ex: 20051116. I want to change all of them in a date format like this 11/16/2005 with out retyping each one. I have tried to change the format but excel will not read it. I have tried to make a macro but excel only changed that one cell not the entire column. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
Linear Mode
