Re: $$Excel-Macros$$ Need to Format Date By Formula

2011-10-25 Thread dguillett1
chg c2 to this =VALUE(TEXT((LEFT(A2,11)),"MM/DD/")) or =VALUE(LEFT(A2,11)) Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Tuesday, October 25, 2011 10:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need to Format Date By Formula Excel Teach

Re: $$Excel-Macros$$ Need to Format Date By Formula

2011-10-25 Thread John A. Smith
Excellent! Thank you for your quick response and your continued teachings. John On Tue, Oct 25, 2011 at 11:56 AM, Sam Mathai Chacko wrote: > =DATEVALUE(TEXT((LEFT(A2,11)),"MM/DD/")) > > OR > > =DATEVALUE(LEFT(TRIM(A2),10)) > > rEGARDS, > > Sam Mathai Chacko > > On Tue, Oct 25, 2011 at 9:22

Re: $$Excel-Macros$$ Need to Format Date By Formula

2011-10-25 Thread Sam Mathai Chacko
=DATEVALUE(TEXT((LEFT(A2,11)),"MM/DD/")) OR =DATEVALUE(LEFT(TRIM(A2),10)) rEGARDS, Sam Mathai Chacko On Tue, Oct 25, 2011 at 9:22 PM, John A. Smith wrote: > Excel Teachers, I need to format 09/14/2011 0938 into 9/14/11 (or a real > date format). Please see attached spreadsheet. > > Thank