Changing Text to a Date

[michael_allen_24]

Hey everyone! Have a quick question for you: I have this text in a cell:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
<TABLE style="WIDTH: 128pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 0in 0in 0in" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=171><TBODY><TR style="HEIGHT: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 0in; WIDTH: 128pt; PADDING-RIGHT: 0in; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0in" width=171>Jul11<o></o>
</TD></TR></TBODY></TABLE>
<o></o>
I want it to display 7/11/2011.<o></o>
<o></o>
Formatting the cell to display the date does not work, probably because it is text? Not sure.<o></o>
<o></o>
What is the easiest formula to automatically do this for me? <o></o>
<o> </o>
Thanks in advance.<o></o>

 

[michael_allen_24]

Thanks!

 

[HalfAce]

Or, just change your original formula to force the result to be a numeric value instead of text. (Same as multiplying by one as danzon did.)
(ie.) Cell C1 =--LEFT(A2,B2-1)

Hope it helps.