| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported dates
I have a huge list of dates that I have imported. Some of them prior to 2000
and some are post 2000. They are in this form 03/22/1999, and 03/23/2001. How do I get excel to recognize these as dates and not text. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
| imported text data converting to dates | Excel Discussion (Misc queries) | |||
| Imported numbers change to dates | Excel Discussion (Misc queries) | |||
| Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
| Using imported Query & Calculating Dates | Excel Worksheet Functions | |||
Threaded Mode
