Date format : mm/dd/yy to dd-mmm-yy format

**plumberef** · 10-24-2012, 07:14 PM

I have a spreadsheet with share data. On the left is the date column. The dates are entered in the mm/dd/yy format. I want to change the dates to dd-mmm-yy format.

How can I use a function or macro to change the date column to my format (about 5000 lines) ?

Many thanks.

**jeffreybrown** · 10-24-2012, 07:20 PM

Look at Text to Columns

Data >> Data Tools >> Text to Columns >> Next >> Next >> Check Date >> Select format >> Finish

**plumberef** · 10-24-2012, 09:10 PM

Originally Posted by jeffreybrown

Look at Text to Columns

Data >> Data Tools >> Text to Columns >> Next >> Next >> Check Date >> Select format >> Finish

Jeff,

Tried and it worked !

Many thanks ! Spent some hours last night trying to do it manually and also trying to figure out a way to use VBA to look at the string and then rearrange the numbers in the string.

This is so much easier !

Many thanks once again !

Cheerio.

**jeffreybrown** · 10-24-2012, 10:14 PM

You are very welcome

----------------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**plumberef** · 05-27-2013, 11:23 PM

Jeffery,

Need your help again.

Tried again this morning and it does not work like before. Excel does not seem to recognise the data in the date column.

Please help. Thanks.

P/S Please disregard my request here. Found the mistake I made. For the date format, I should select what is the current date format and NOT what I want it to be!