Convert Date Format from yyyy-mm-dd to dd mmm yy using VBA

Hello, I am using Excel 2003 on Windows XP. Could some one please help me with a date conversion as follows:

In column F (F2:F65000) I currently have dates in yyyy-mm-dd format (e.g. 1970-04-27).

I need this date format to be changed to: dd mmm yy format (e.g. 27 Apr 70).

Please refer to my attached image showing examples of the date formats:

Examples of Date Formats.jpg

I can do this manually, but I have 65,000 to do.

Any assistance would be greatly appreciated,

Kind regards,

Chris

You should have posted a workbook, not a picture. If the cells are holding text values then you could use a helper column with:

Please Login or Register  to view this content.

, copied down.

Hi,
if you insist on VBA solution, get this attachment...
I understand that you are asking for VBA solution because of easy using, but i'd like to make your intention on fact that you can solve this problem with one additional column with following code (example for G2 cell):

Please Login or Register  to view this content.

and formatting this additional column as USER FORMAT - dd mmm yy
Anyway, your VBA solution for colum F should be

Please Login or Register  to view this content.

as you can find in VBA module of attached file.


Reagrds,