Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Some work with the text to columns but they are not all exactly the same,
Feb 1/04 doesn't work because I guess it isn't Feb 01/04 and sometimes Mar is written as March. The DATEVALUE function that bob suggested seems to work for most of them and can be modified to work of the ones with only 1 day value. Give this formula a try... =DATEVALUE(MID(A21,FIND(" ",A21)+1,FIND("/",A21)-FIND(" ",A21)-1)&"-"&LEFT(A21,3)&"-"&RIGHT(A21,2)) Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
Text and dates into one cell without loosing date format | Excel Discussion (Misc queries) | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) |