ExcelBanter - date extraction

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - date extraction (https://www.excelbanter.com/excel-worksheet-functions/255157-date-extraction.html)

I have a macro set up that pulls out the dates from my information.

I am not sure but I think what I have below is the spot that defines the
date format to pull out my dates from my data. If I put 2/2/10 it does not
pull out the date. If I put 02 it does pull out the date. Is there a way so
it will pull it out whether I put 2 or 02 for the month?

Selection.NumberFormat = "m/d/yy;@"
Thank You

Selection.NumberFormat = "m/d/yy;@" simply formats the date to Text

Can you post the entire macro?

Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 16:21:01 -0800, Donna wrote:

I have a macro set up that pulls out the dates from my information.

I am not sure but I think what I have below is the spot that defines the
date format to pull out my dates from my data. If I put 2/2/10 it does not
pull out the date. If I put 02 it does pull out the date. Is there a way so
it will pull it out whether I put 2 or 02 for the month?

Selection.NumberFormat = "m/d/yy;@"
Thank You