| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I convert Text into Date? (See inside)
I have cells that contain Dates such as "Aug 23 2009" but, they were copy
pasted in, and Excell does not see them as dates, is there anything I can run that can convert them? I want to be able in the end, that when I open Excell, it can jump to Today;s date. And alternatively, to have some kind of search option, that will lead me to any date I want. But that is part 2, just looking to get the text recognized as Dates to start. Thanks in Advance, Yoni |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text date to mmddyyy date | Excel Discussion (Misc queries) | |||
| convert a text date to a true date | Excel Discussion (Misc queries) | |||
| how do i convert text to date (mm/yy text to mm/dd/yyyy date)? | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| How to convert date to text | Excel Discussion (Misc queries) | |||
Threaded Mode
