| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho
Hi,
I have a column "A" of "dates" in text of DDMMMYY format, such as "30Mar98". I either need to convert all the values in the existing column to datetime values (YYYY-MM-DD) or create a new column "B" that contains the converteed values. How is this done? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
| can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions | |||
| Help Convert "MM/DD/YYYY" to "YY:DDD" | Excel Worksheet Functions | |||
| Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
