format dates to mm-dd-yy

W

Wanna Learn

Hello I received a workbook and all the dates are formattted as text and
look like this 090323(means Mar 23 09) . How do I format this as a date to
read Mar 23 09 Thanks in advance
 
T

T. Valko

This **might** work...

Select the cells in question
Goto the menu Data>Text to Columns
Click Next twice
In step 3 of the wizard, under Column data format select Date>YMD
Finish

That might convert those entries into a true Excel date then you can format
in the date format of your choice.
 
J

Jacob Skaria

Select the column
Data-->'Text to Columns'
Next-->Next--> will take you to Step3 of the Wizard

Select Date and from drop down select YMD
Hit Finish.

If this post helps click Yes
 
A

Andy_N1708 via OfficeKB.com

Well I think the easiest and straight forward method would be breaking the
column into 3. One with Left(A1,2), then Mid(A1,3,2) and lastly Right(A1,2).
Once you've done this use =CONCATENATE(C1,"/",D1,"/",B1) which will combine
the three column into the date you want to show. It's a tad long but would do
the job.
 
Top