| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2000 worksheet where I want to convert date format
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! |
| 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) | |||
Threaded Mode
