format dates to mm-dd-yy

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top