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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported dates
Say the "text" dates are in column A. Select column A and pull down:
Data Text to Columns... Next Next check Data and pick the correct format. -- Gary''s Student - gsnu200790 "Justin" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported dates
Thanks. That worked perfectly!
"Gary''s Student" wrote: Say the "text" dates are in column A. Select column A and pull down: Data Text to Columns... Next Next check Data and pick the correct format. -- Gary''s Student - gsnu200790 "Justin" wrote: 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. |
Reply |
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 |