| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 worksheet where I want to convert date format
So very cool!
Thanks for the help! "Ron Coderre" wrote: I think you can do what you want all in one step: Select the "date" cells DataText-to-columns Delimited...Click Next (Doesn't matter what the delimiter is)...Click Next Click the Date option and set the dropdown to YMD...Click Finish That should turn those numbers into dates. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Russell-stanely" wrote: I have a worksheet (in 2000) that was sent to me. The information in the worksheet was culled from an Access database that I have no access to, and saved to Excel. There are several columns of dates that came over as "general" in this format: 20031125. I want to quickly convert this into the proper date format of 11/25/03, but I cannot seem to figure out a quick method to do it in Excel 2000. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
