| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates in Excel - yyyymmdd, not formatted, how do I format this?
I have a column of dates, they are in yyyymmdd format (no slashes or
anything) and they're text. I cannot format them, how do I do this? Basically, I want to change 19700429 to 4/29/1970, but for a whole column of different dates (dates not in sequential order). Thanks in advance!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates in Excel linked with Outlook Calendar | Excel Worksheet Functions | |||
| Why won't it Excel fill in weekly dates now, changes them to daily | Excel Worksheet Functions | |||
| how do I select unique dates from a database in Excel? | Excel Worksheet Functions | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
| dates in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
