Excel Convert Text to Date Yogesh Guptas Excel Tips. Many of us get into a situation when the dates in our data are coded as text. Excel does not recognise such text entries as date and we can not use them for any calculation purpose. However you can easily covert them to date by the help of excel formula. You may have a situation where the text of the date is actually as date but being a text string it is not recognised as date by excel. Technology keeps you connected everywhere you go, helps you capture every moment makes your life a bit easier stay uptodate with tips tricks from eHow. Want a better grasp of Excel, but not sure where to start This list will help. It could be 1. 2Oct2. You can easily convert them using Datevalue formula. Assuming you have text in cell A2, the formula you need to enter is DATEVALUEA2However many time we get data stored like 2. Here October 1. 2, 2. First 4 digits as Year, next 2 Digits as Month, next 2 Digits as Day. It becomes little tricky but it can also be converted to date using combination of Mid and Date function of excel. Assuming you have date stored as 2. A3 of you worksheet, you can convert it to date using DATEMIDA3,1,4,MIDA3,5,2,MIDA3,7,2Logic behind this formula is devide the text into Year, Month and Day separatly. This is done by using MID function of excel. Nero Express 6 Free Download Windows 7 64 Bit. Once you are able to break text string into three different components of Date. You put these in the Date Function of Excel. Syntex for Excel Date function is DATEyear, month, day. Images_2012/popup_1.jpg' alt='Pop-Up Excel Calendar Serial Number' title='Pop-Up Excel Calendar Serial Number' />MIDA3,1,4 2. Somente Para Seus Olhos more. This Year Value in Text String. MIDA3,5,2 1. 0 This is Month Value in Text String. MIDA3,7,2 1. 2 This is Day Value in Text String. This is converted into Grand Formula DATEMIDA3,1,4,MIDA3,5,2,MIDA3,7,2If you see the formula I have just brokenup the text string using MID in combination with Date function. See picture below to understand it better. Top VIdeos. Warning Invalid argument supplied for foreach in srvusersserverpilotappsjujaitalypublicindex. INSTALL ON A NEW MACHINE 20172QE. UPDATE EXISTING VERSION 20173QG. Download this to install HITech Pawn software on a new server or additional workstations on your. RequestCracks. com Request a Crack, Dongle Emulator or Dongle Crack. Dongle Emulation Service for any software.